Combine two files one with headers and the other with data

[Aimanx2]

Hi all,

I am struggling, i have two .csv files. one consists of column names and the other is a data dump without headers (7 million + rows). Now i want to handle this data in Alteryx and input the .csv file with the headers into the data dump .csv to be able to read the data properly.

However i cant seem to find a way to do this. i have tried append and joining the data in multiple ways but nothing seems to give back file 1 as headers and file 2 as data in a combined output.. Can someone help me out?

[binuacs]

@Aimanx2 have you tried the Dynamic Rename tool? IF you take a look at the given Dynamic Rename tool example you can see the similar use case

[MilindG · Accepted solution]

I have attached the file

[Aimanx2]

Thank you both! the .yxmd file attached gave the desired solution!