This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have built a workflow that grabs data from a clients excel file. Each month they send me a new one with the same dimensions. Is there a way to bring in each new months data and compile it with the last without having to copy and paste the workflow below each other? I want to be able to somehow just add the new month file while keeping all the previous months without having to switch each month in the input data tool because I will than export it into tableau to show past performance. Thanks!
Would that still work if in my workflow? I am using the select records tool to gather specific rows in that file so I cant have them become unionized because it wouldn't pull the selected rows correct?
It could work. Are the same number of records selected each month? Then I'd use a Sample tool instead of Select records, with a Grouping field on whichever field indicates the month (or the different file). An easy way to include a field like this is in the Input tool, set the Output File Name as Field to File Name Only, and use that in the Sample tool.
Otherwise, I'm thinking that you could use a Directory tool (read all files)+ Sort (most recent on top)+ Sample (first record only)+ Dynamic Input tool to select just the most recent file, go through the workflow, and in the Output File stage, choose to append onto an existing file.