Hi,
I have an excel file with over 80 tabs. I used "List of Sheets" macro and "Batch Macro" to import them all into alteryx.
But it looks like the column arrangement isn't same across all the sheets.
Here is a sample data set:
Name | code | date | org | plan | amount | test amount |
ABC | EEC | 2/4/2019 | 110 | EZ4 | $2,000.47 | $ 250.64 |
EFG | ER120 | 3/12/2019 | 110 | EZ8 | $6,400.87 | $ 199.00 |
IJK | EEC | 3/26/2019 | 200 | AR18 | $8,000.00 | $ - |
date | name | amount | org | plan | test amount | |
2/18/2019 | TOOR | $ 1,643.89 | 200 | TX18 | $7,100.32 | |
5/12/2019 | ROTZ | $ 348.98 | 210 | TR18 | $100.90 | |
8/8/2019 | WEL | 5000.21 | 110 | EZ6 | $86.00 | |
org | date | name | amount | test amount | code | plan |
110 | 2/18/2019 | ABC | $7,100.32 | $ 250.64 | EEC | TX18 |
110 | 5/12/2019 | EFG | $100.90 | $ 199.00 | ER120 | TR18 |
200 | 8/8/2019 | IJK | $86.00 | $ - | EEC | EZ6 |
I want to get Date, Amount and Test Amount from this data set.
Is there a way to rearrange the macro output according to the column name, so that Date comes under Date and Amount comes under amount?
Thank you
Solved! Go to Solution.
Go to your Interface Designer properties in your batch macro and change this configuration
If the names are exactly the same, the config by name option should work.
Cheers,