convert the haphazard excel data into consumable format
- 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 have a peculiar situation where the haphazard excel data needs to be converted into consumable format.
Attached excel file has two tabs 1) Raw Data 2) Desired Results.
Kindly let me know if this is doable. Candidly speaking, I have run out of ideas and need help in getting this fixed.
thanks
Subbu
- Labels:
- General
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SubbuSharma,
From looking at the dummy data, I am curious if your data started out as a .csv file? If so, it should remain in a .csv file and then you should use the pipe delimiter ("|") when importing the .csv in Alteryx.
If the data was never in .csv format, you can try the solution attached :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Megan for the workflow. However, I was looking for an output something in the "desired results" tab.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SubbuSharma , I have created the workflow as per your desired output. Please check and accept my solution if it fulfills your requirement.
Thanks!!
