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.
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