Can I use DataShuttle to consolidate data?
I have many files that are formatted the same, but contain different data. I would like to use DataShuttle to consolidate the data into a single Smartsheet spreadsheet via an Upload Workflow. I simply want the data from each uploaded file to be added to the target sheet. Is this possible?
Here is the process that I am currently using.. it is not ideal..
Target -> Workflow Action: Merge data into the target based on a key column value
Target -> Row options: Add rows to the sheet as they are added to the source file
This method enables me to populate the target sheet with data from each file upload. However, it forces me to include a Row ID in each individual data file. I would like to avoid having to include a Row ID or any other unique identifier in my data files if possible.