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?
Solved! Go to Solution.
Union by position rather than name :
You probably missed it, it's the top dropdown selection in the Union tool
Thanks!
The following is also useful for this problem.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-column-headers/td-p/50563