Hello,
i want to crosstab multiple specific fields, which can be dynamic.
At the moment it looks like this:
place | workers | valid from | day | time |
B20 | 1 | 2023-01-01 | Monday | 05:00 |
B20 | 1 | 2023-01-01 | Monday2 | 23:00 |
B20 | 1 | 2023-01-01 | Tuesday | 06:00 |
B20 | 1 | 2023-01-01 | Tuesday2 | 20:30 |
... |
But i need it this way:
place | workers | valid from | day | start | end |
B20 | 1 | 2023-01-01 | Monday | 05:00 | 23:00 |
B20 | 1 | 2023-01-01 | Tuesday | 06:00 | 20:30 |
... |
I tried it with additional columns but couldnt figure out, how to get the specific fields in the second row the be placed at the right spot.
Is there a way to do this with alteryx?
Thanks a lot in advance
Solved! Go to Solution.
Hey @jonasebner, how does something like this look? The Formula tool generates a cleansed weekday for you to group on, as well as creating Start/End flags based on whether it's the 2nd instance of that day (contains 2). Then we use these to group on and employ as our new headers respectively:
works perfect, thank you :)
This works also, thank you