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

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.

rename.yxmd