Imported Table Remove All Rows
If I have an imported table and want to remove all rows of data (outside of the Header row) every time a workflow completes, is there a more efficient way to accomplish this other than the options I listed below?
Tables: Delete a row
- require batching over the imported table to extract the unique identifier and then using that as the lookup value in theTables: Delete a row
actionTables: Copy a table to another table
- require constructing a blank table in a workflow run with the same headers and then usingTables: Copy a table to another table
action withOverwrite existing table
set to TRUE.
For context, the use case requires individual runs of a workflow (each time a file dropped on SFTP) to write to an imported table and then clear out that table after all workflows complete.
Answers
-
My initial recommendation would be to use Tables: Copy a table to another table with the Overwrite option you mentioned. Assuming the table column headers are always the same, you can store a header-only Excel file as a file field default value. With this approach, you only need the one action.
1 -
I need to fill the destination table with an ID
I have tried to use the ID directly and also between {{ }}
But it doesn't work
Documentation said
"If necessary, you can enter the Table ID directly. Change the left hand drop-down to ID then enter the ID manually. Learn more."
but the drop-down doesn't existElia
0 -
Hi @Elia_321768,
I will reach out to you from help@catalytic.com and schedule a screen share call with you to help you with your setup.
Thank you,
0 -
@Elia_321768, based on your question here, can you use Excel: Save Spreadsheet to Table for your case?
Excel: Save Spreadsheet to Table includes an Overwrite existing table option to replace spreadsheet data onto the Table ID.
Excel: Save Spreadsheet to Table
https://help.catalytic.com/docs/excel-save-spreadsheet-to-table/Overwrite existing table
https://help.catalytic.com/docs/excel-save-spreadsheet-to-table/#overwrite-existing-tableFeel free to send a reply to my email message if you prefer to discuss over email and set up a phone call together to discuss further.
0 -
@Jozef_783863, so when using Tables: Copy a table to another table in the manner you mention above will the table name be changed based on the value of the Output field prefix or is that only used if the existing table is not overwritten?
0 -
@Elliott_161118 Based on my test, the source table name remains the same. Output field prefix from Tables: Copy a table to another table only returns summary information, rather than alter the source table name.
Tables: Copy a table to another table > What will this output?
https://help.catalytic.com/docs/tables-copy-a-table-to-another-table/#what-will-this-outputImage 1 - Test Setup
Image 2 - Source Table After Test
1