Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Add header to multiple files and append them as one output


I get csv files auto generated weekly from client but they comes without header. The column remain constant in each file and data schema remains same. 
I have been given seperate csv file with header that can be mapped to all those file. The number of files without header are 50+

the task is to map the sample header file with all 50+ files and append them into one single file. any idea?





Since your files are .csv and have the same schema, you can use a wildcard * to read in all files and Union to the header.csv file - 



You can configure the Union to "Auto Config by Position" if the header.csv column order matches the other 50+ files and set Output Order where the .header csv is always first -