How to combine multiple .CSV files into one file

[Anjankumar2021]

@binuacs /Hi Team, Kindly assist on the below issue.

i have 5 CSV input files  in a particular folder.

File Names	Sheet Names
Anjan_SALE_20240701.csv	Anjan_SALE_20240701
Anjan_SALE_20240703.csv	Anjan_SALE_20240703
Anjan_SALE_20240704csv	Anjan_SALE_20240704
Anjan_SALE_20240628.csv	Anjan_SALE_20240628
Anjan_SALE_20240702.csv	Anjan_SALE_20240702

Output: need to combine 5 csv files into one file. please note that all files have same data headers(column names).

[JosephSerpis]

Hi @Anjankumar2021 have a look at this article from the Alteryx community it will walk you through the various approach you can take to tackle this challenge in Alteryx.

[binuacs · Accepted solution]

@Anjankumar2021 Attaching two method 1. with dynamic input, 2.with batch macro

[Anjankumar2021]

Dynamic input worked for me. thank you so much for your help.

[Anjankumar2021]

@binuacs 

is there any way that we can add sheet_name as one column in input files  after or before combing 5 CSV files.

required output:

Sheet Names

Anjan_SALE_20240701

Anjan_SALE_20240701

Anjan_SALE_20240701

Anjan_SALE_20240701

Anjan_SALE_20240701

Anjan_SALE_20240701

Anjan_SALE_20240701

Anjan_SALE_20240703

Anjan_SALE_20240703

Anjan_SALE_20240703

Anjan_SALE_20240703

Anjan_SALE_20240703

Anjan_SALE_20240703

Anjan_SALE_20240704

Anjan_SALE_20240704

Anjan_SALE_20240704

Anjan_SALE_20240704

Anjan_SALE_20240704

Anjan_SALE_20240704

Anjan_SALE_20240628

Anjan_SALE_20240628

Anjan_SALE_20240628

Anjan_SALE_20240628

Anjan_SALE_20240628

Anjan_SALE_20240628

[ChrisTX · Accepted solution]

@Anjankumar2021 in the Dynamic Input tool or the batch macro, in the template file you specify, use the option for Output File Name as Field.

Chris