Transformation help needed
- 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
Dear All,
I have a source data like below -
And I want to convert this data to below format -
Using Alteryx how can I achieve that? Need help.
Solved! Go to Solution.
- Labels:
- Help
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What is the Sl No. ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can ignore the 1st column.
I want to convert my data from below format -
To this format -
Already uploaded the input excel file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've attached my initial thoughts on getting it in that format. One thing to note would be Alteryx works on a table format and the structure you want has columns at different levels which isn't a good format for tables.
I would also point out its a lot easier to help with problems like this if you say specifically what your struggling with rather then just post the entire peace of work for someone else to do.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your help, but it's not the entire piece of data. I just wanted to know how to transform from source to destination format.