Download Tool to CSV output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Download
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Ilango ,
have you tried the dynamic rename tool yet?
https://help.alteryx.com/current/DynamicRename.htm
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Mark,
Great. It worked perfectly. Thank you.
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)