How to union multiple csv files that do not contain headers (header in separate csv)

[jackdaniels]

I have 100+ data sheets and one separate file containing headers.

e.g. header csv

Category

Size

Value

data csv

Top	L	12
Bottom	M	15
Middle	M	16

of course the data csv will not union correctly, but I have tried using the header csv as a template in the dynamic input but I am still getting errors.

csv "has a different field name than the 1st in the set"

How can I use the header csv to union all the csvs?

[cmcclellan · Accepted solution]

Union by position rather than name :

You probably missed it, it's the top dropdown selection in the Union tool

[jackdaniels]

Thanks! 

The following is also useful for this problem.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-column-headers/td-p/50563