Hi All,
I need to collate data from Excel files extracted from multiple markets, this data then gets compared to a Baseline data set.
My workflow starts with a Directory input, then a filter to pick the files required and then a Dynamic input to collate all the data and append with a file name. The challenge, not all of the countries are on the same version of software which means there are varying numbers of columns. This leads to those files that don't match the template being excluded from the input!
What is consistent are the Key fields for the data validation. Is there a way of of finding the files then selecting just the required columns for the dynamic input?
I've given examples of the columns in the files and the workflow I am using.
Thanks in advance for any help.
