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

Question

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

e.g. header csv

CategorySizeValue

data csv

Top L12BottomM15MiddleM16

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 Answer

Union by position rather than name :

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