community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

Atom

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?

 

Highlighted
Alteryx
Alteryx

@Aurz 

 

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 - 

JessieC_0-1572676655199.png

 

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 - 

JessieC_1-1572676744649.png

Labels