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 the
Tables: Delete a rowaction
Tables: Copy a table to another table- require constructing a blank table in a workflow run with the same headers and then using
Tables: Copy a table to another tableaction with
Overwrite existing tableset 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.