Hi all,
I'm new to Alteryx so I'm struggling a bit. I'm trying to write a workflow that pulls xlsx files that have the same column structure from a directory and merge them into one .yxdb at the end. I've found on this community that it was possible to do this using the Directory tool and Dynamic input one. My issue is the following :
I'm trying to keep in a new column the corresponding file name for the different tables. If I had to schematize this it would look like this :
file1.xlsx
entity | score |
A | 3 |
B | 4 |
file2.xlsx
entity | score |
C | 5 |
Output :
entity | score | file name |
A | 3 | file1.xlsx |
B | 4 | file1.xlsx |
C | 5 | file2.xlsx |
How would I manage to do that ?
Thanks !
Habib Fares
Solved! Go to Solution.
Please see below how you can do this:
2 in the macro select the add file name
Attached the workflow,
If this solve the need please mark it as solved. It will help others
Regards,