SOLVED
Row 1 to column header
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mark007
8 - Asteroid
‎06-11-2022
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all - I am working on one of the weekly challenges, challenging in itself but I'm there... or almost.
I have the attached output and all I need to do is move the 1st row to become a column header. I can export to excel, reimport and use the settings in the input tool but surely there is a better, less messy, solution?!
Thanks all!
Mark
Solved! Go to Solution.
Labels:
- Labels:
- Output
- Tips and Tricks
- Transformation
- Workflow
5 REPLIES 5
17 - Castor
‎06-11-2022
08:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @mark007,
All you need is the dynamic rename tool and just select take field names from first row 😄
Adrian_T
Alteryx Alumni (Retired)
‎06-11-2022
09:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @mark007, here's a great resource on learning about the Dynamic Rename Tool. 😎
‎06-11-2022
01:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎06-11-2022
03:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @mark007 ! have a good one too ! 😄
kh9362003
5 - Atom
‎11-19-2024
09:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
FYI this post just saved my life. I am so happy I found this and it worked like a charm!!
