HI team,
I am very new to Alteryx so apology if I missing something
Ask - We have around 145 excel to be loaded via Alteryx and this can increase in future and solution should be dynamic enough to accommodate these
I tried to used file directory and dynamic input to load but I got stucked as schema of all files need to be exactly same in this approach
Problem
1. Number of file is not fixed
2. Columns too are not fixed in these files
3. Column order is not fixed
Solution that I can think if can be achieved in Alteryx, Kindly help
We can have a master file with lets says list of 03 Columns with there order that must be loaded in final table
So if we can check each file maybe in a loop for these 03 columns which can be stored in a master lookup table
Scenario 1 - If all of these columns are found in File number 1 and in order described in Master fie no action load in final table, Scenerio_1 file data will be written in Final_output file (exxamples attached)
Scenario 2 - If all of these columns are found in File number 2 but not in order I means maybe they are not in Column 01 to 03 we re-arrange the columns in file 2 as per master fie order, Scenario_2 file should be arranged as Scenario_2_Rearranged file the should be as Final_output fie
Scenario 3 - If we have only 02 columns in File 3 we arrange in order for remaining 01 column we add columns in order with blank values, Scenario_3 file should be arranged as Scenario_3_Rearranged file the should be as Final_output fie
Since we can attached only 05 files I have made sheets instead of files.
Once all above 03 scenarios are handled we load the files with 03 a column and remaining n number of columns as transpose
Kindly help
