How to append append field names to a text file without headers

[ai5703]

I have 2 delimited text files. The first has just one row with the headers aka field names. The second is the data file with many rows without the headers/field names.

Is there a way in Alteryx that I can use to append the first file to the second resulting in a data file with  field names in addition to the data?

[michael_treadwell · Accepted solution]

Try unioning the two datasets together with the Union tool, making sure that your file with the headers is first in the output order.

Then use the Dynamic Rename tool selecting 'Rename Mode: Take Field Names from First Row of Data'

Make sure to uncheck 'First Row Contains Field Names' from your Input tool if necessary.

[RodL]

And just a note, you will probably need to set the Union option to Auto Config by Position.