In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Including file names into the the files consolidation output

Ekaterin_a_s
5 - Atom

Dear Community,

I am consolidating several csv files in one file in the following way:

1). Input directory tool: linked the folder with my input files

2). Filter tool: filtered the csv files. This gives me the list of the files I want to consolidate

3). Dynamic input tool: combines the files in one table

 

Now I would like to add the file names into the final output table. I have tried using "Select" tool and "Append fields", but it seem not to be working like this. Can anyone help?

 

Thanks in advance!

Best regards,

Ekaterina

2 REPLIES 2
Chaoued
8 - Asteroid

Use the Input Data Tool with “Output File Name as Field” option

Instead of just using the Input Directory + Dynamic Input, configure the Input Data tool (or Dynamic Input) to include the file name.
In the Input Data tool, check the box: “Output File Name as Field”
and choose Full Path or File Name Only.

Chaoued
8 - Asteroid

@Ekaterin_a_s  just put this option in your dynamic input setting 

Chaoued_0-1764690999485.png

 

Labels
Top Solution Authors