Keep File name when merging multiple files with dynamic input

[Hfares]

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

[messi007 · Accepted solution]

@Hfares,

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,

[jamielaird · Accepted solution]

Hi @Hfares ,

You can adjust the setting below to output the filename as a field: