Hello,
I am trying to download a file from SFTP and then write to Azure Data Lake as a CSV file directly. I wanted to do this by neither downloading the file to local computer nor using RegEx tool. I got to a point where I am able to see split the downloaded data into rows and then to columns. See attached.
My question is how can I replace current column headings in output with first row in output? Once I am successful, I will then replace browse tool with Azure Data Lake output tool.
Thanks in advance.
Ilango
Solved! Go to Solution.
@Ilango ,
have you tried the dynamic rename tool yet?
https://help.alteryx.com/current/DynamicRename.htm
cheers,
mark
Hello @Ilango ,
Use the dynamic rename tool and set it to 'take names from first row of data'
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Hello Mark,
Great. It worked perfectly. Thank you.