hii all
im new to appian, please tell me 1.how to create a staging table ,
2.and alos how to clear the staging tables
3. how to write staging table data to main data table using script task
Discussion posts and replies are publicly visible
1. Staging table is just like any other table but the difference is that we do not treat it as the main table.
2, 3. You can write the data to the staging table based on your use-case. If it has a primary key column, then you can write it via Write to DSE but if it doesn't have a PK (importing excel to DB) then you can use the smart service. And based on the same question, you can decide which way to clear and populate the main table. Either use delete from DSE smart service, or run a SQL query using a Smart service or create an SP.