@binu_acs /Hi Team, Kindly assist on the below issue. i have 5 CSV input files in a particular folder. File NamesSheet NamesAnjan_SALE_20240701.csvAnjan_SALE_20240701Anjan_SALE_20240703.csvAnjan_SALE_20240703Anjan_SALE_20240704csvAnjan_SALE_20240704Anjan_SALE_20240628.csvAnjan_SALE_20240628Anjan_SALE_20240702.csvAnjan_SALE_20240702 Output: need to combine 5 csv files into one file. please note that all files have same data headers(column names).

How to combine multiple .CSV files into one file

Anjankumar2021

@binu_acs /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).

Workflow

Accepted answers

binu_acs

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

Combine_CSV_13102024.yxzp

ChrisTX

@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.

Screenshot 2024-10-14 062858.png

Chris

All comments

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.