Dynamically Extracting and Inserting File Names into CSV Spreadsheets Using Alteryx

[Masond3]

Alteryx Community,

I need your expertise.

A colleague has sent me a zip file containing 45 CSV files, each named using the convention "Id_Name."

Unfortunately, the Id is not present within the spreadsheets themselves.

Is there a way to dynamically extract the id / name from the title of each CSV file and insert it into the corresponding spreadsheet as a column called "file name" & be populated for the number of rows in the excel ? 

Example File Names 

File Name  = 11111_Mason ( Has 5 Rows) 
File Name =  11112_Alteryx  (has 3 rows)

File Name =  11113_Google ( Has 7 rows)

Looking forward to your help 

Many thanks 

[Masond3 · Accepted solution]

Hi,

I have solved this.

In the Input Data tool, there is an option called "Output File Name as Field." Within this option, you have three choices:

• "No"
• "File Name Only"
• "Full Path"

If you select "File Name Only," the file name will be included in the output.

[OTrieger]

Cool 😎