Data Cleaning
- 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
I am stuck at wrangling this dataset, as I have used Text to column and Regex but am stuck at transforming the header into separate columns.
I am asking the community please help me
Above image shows the sample data, while the below image is the desired result, Thank you
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @SS_95,
Here is one way to do this:
Any questions or issues please ask!
Hope that Helps
Ira Watt
Technical Consultant
Watt@Bulien.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am getting the final result as with column name 1, 2, 3, 4, 5
I have attached the dataset for your reference, thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SS_95 That's strange I just tried it:
I've zipped the workflow with the data below. Any stage of the gif different to what you see?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much it worked!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @SS_95 😄 Glad to hear !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was given an assignment in Alteryx, I haven't used the tool much but this is what I had to work on
Would it be possible for you to help me out?? Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SS_95, that doesn't sound to complicated to do. I would just watch the Interactive Lessons - Alteryx Community on the relevant topics. Interactive Lessons - Alteryx Community. If theres any part of the problem in particular you don't understand how to do in Alteryx open a question on the discussions board.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much
