Afternoon folks,
I've got some data coming from a scheduling system that comes out a tad funnier than I'd like.
It extracts into a HTML only format that displays as below;
Person Name | Start time | End Time | Break times |
Bob Mar | 08:00:00 | 16:30:00 | 09:45 - 10:00 |
13:30 - 14:00 | |||
14:15 - 14:30 | |||
Elvis Pres | 09:45:00 | 18:15:00 | 11:00 - 11:15 |
15:15 - 15:45 | |||
16:00 - 16:15 | |||
John Frus | 09:00:00 | 17:30:00 | 10:30 - 10:45 |
12:00 - 12:30 | |||
14:30 - 14:45 |
Which doesn't display in the format I'd like if I'm honest because if I sort by start time then the blank cells are just going to the bottom and are no longer allocated to the above row.
How I'd like it to display is as follows;
Person Name | Start Time | End Time | Break 1 | Break 2 | Break 3 |
Bob Mar | 08:00:00 | 16:30:00 | 09:45 - 10:00 | 13:30 - 14:00 | 14:15 - 14:30 |
Elvis Pres | 09:45:00 | 18:15:00 | 11:00 - 11:15 | 15:15 - 15:45 | 16:00 - 16:15 |
John Fru | 09:00:00 | 17:30:00 | 10:30 - 10:45 | 12:00 - 12:30 | 14:30 - 14:45 |
I have absolutely zero idea how to even start doing something like this if I'm perfectly honest as I'm a tad of a new guy at Alteryx, so any help would be appreciated it!
Solved! Go to Solution.
Hey Patrick,
Turns out I can't view the workflow as the org is using an old version of Alteryx.
@NikSTHF I changed the xml so it should be compatible with anything after 10.5
Still getting the same error and I'm on 10.6.
Very frustrating as I bet it'll fix it right up!
@NikSTHF - I repackaged @patrick_digan's workflow in hopes you can now open it. Please see attached.
@NikSTHF Alteryx was changing the macro versions unexpectedly. Hopefully I've caught them all this time...