Hello, I have a folder of different output files for different months (I.E. Jan, Feb, Mar, Apr) and I want to automate the process of inputting certain files into a workflow. These files all have the same schema and same sheet names. I need to compare two separate files that are 3 months apart so if we are working in April, I will need to compare that data to the Jan data. I will then need to run the same workflow the next month so in May, I will need to compare that data with the data output from Feb.
After inputting those two files into Alteryx automatically, I would like to compare the data on the two spreadsheets based on the same named sheet from both files to create two new columns of data. (I.E. I would like to create a new column called Direct Send Quarterly Metric where on the April spreadsheet we take the Directly Send for each category divided by the total Directly Send and then take that total and subtract it from Jan Directly Send divided by the total Directly Send).
The second column of data to be created is similar to the first where on the April spreadsheet we would take the Direct Received for each category and then divide that by the total Direct Received number, then we would subtract the Jan Direct Received divided by the total Direct Received and that would give us the new metric.
This would need to be done for each sheet on the excel files where we compare the data from the two spreadsheets based on the sheet name (Company A from April would need to be compared and have the new metric created based on Company A sheet from Jan spreadsheet.
Once the new metrics are created for each spreadsheet, I would like if all the data could be combined into one spreadsheet with the new columns as part of the data set and the sheet names from the original files carried over into the new output file.
I have attached four sample excel files as an example of what would be in our file that we get our data from. Hope this was not too confusing, but if I can clarify anything, please let me know.
Thanks
