SOLVED
same column headings, cross tab group
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
SAPaul
8 - Asteroid
‎01-23-2020
03:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Room Number | Reason for Out of Order | Expected Date Back in Order | Expected days out of order | Add another Out of Order room? | Room Number | Reason for Out of Order | Expected Date Back in Order | Expected days out of order |
101 | Plumbing & Maintenance - Shower/Toilet/Sink | 24/01/2020 | 1 | Yes | 102 | Leak & Damp Carpet/Wall/Ceiling | 25/01/2020 | 2 |
I have data that comes in in this format, alteryx then renames the headers because they have the same name. In the end i want it to look like this
Room Number | Reason for Out of Order | Expected Date Back in Order | Expected days out of order |
101 | Plumbing & Maintenance - Shower/Toilet/Sink | 24/01/2020 | 1 |
102 | Leak & Damp Carpet/Wall/Ceiling | 25/01/2020 | 2 |
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
1 REPLY 1
16 - Nebula
‎01-23-2020
03:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @SAPaul ,
Hope this helps:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)