SOLVED
Multiple Column Transpose with Rename
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
Wixard
8 - Asteroid
‎03-21-2020
07:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I would like to convert a table that has this sample structure
Blue | Red | Green | Blue1 | Red1 | Green1 | Blue2 | Red2 | Green2 | |
Attribute | 1 | 2 | 3 | 10 | 20 | 30 | 100 | 200 | 300 |
Scale | 4 | 5 | 6 | 40 | 50 | 60 | 400 | 500 | 600 |
into this
Colour | Code | Price | Dimension | |
Attribute | Blue | 1 | 10 | 100 |
Scale | Blue | 4 | 40 | 400 |
Attribute | Red | 2 | 20 | 200 |
Scale | Red | 5 | 50 | 500 |
Attribute | Green | 3 | 30 | 300 |
Scale | Green | 6 | 60 | 600 |
The labels "Colour", "Code", "Price" and "Dimensions" are not actually in the first table, so would need to add that in within Alteryx designer.
What formula is needed in the RegEx tool to remove the 1 and 2 after the colour names in first table.
Solved! Go to Solution.
Labels:
- Labels:
- Regex
- Transformation
2 REPLIES 2
17 - Castor
‎03-21-2020
07:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-21-2020
11:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Had to build on what you sent to do a few more things I needed, but was exactly what I was looking for.
Thanks a lot for your help @Thableaus!!!
