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
