Hello, I'm using Alteryx to generate a mapping file in Excel which will be updated every time I re-run my workflow. I only see options to drop (delete) the Excel Table or Append it however I only want to append new records. What's the simplest way to do this with the least manual intervention in my workflow? Thanks.
Solved! Go to Solution.
One simple way would be to read from your target file and perform a join to your existing workflow. The records that do not meet a join criteria (would be presented in the left our right outputs of the join tool) would be your new records. You could then use the append option and achieve the desired result.
If you only want to Append new records, and not update existing records, there is an option called "Append To Existing Sheet" with using the Microsoft Excel (*.xlsx) file format.
Is this not an option for you, or is it not behaving as expected?
@Joe_Mako,
Thanks but it's not working as expected because the Append is adding ALL records, not just the new ones.
Hi @ Joe_Mako,
It's not working as expected because Append is adding all records to my mapping file, not just the new ones.
One option is you can perform a Join just prior to output with your existing file, that way it outputs just the new records.