Hey guys, hope everyone's doing well, so i got a problem with Alteryx Designer where i want to change the way i view the data of my table, gonna show a example to make it easier to understand:
I have this:
Name | Date | Free Hours |
Lucy Stevens | 21/05/2021 | 0 |
Lucy Stevens | 22/05/2021 | 9 |
Pietro | 21/05/2021 | 9 |
Pietro | 22/05/2021 | 9 |
Manoel | 21/05/2021 | 9 |
Manoel | 22/05/2021 | 0 |
And i want this table above to turn into this:
Name | 21/05/2021 | 22/05/2021 |
Lucy Stevens | 0 | 9 |
Pietro | 9 | 9 |
Manoel | 9 | 0 |
Solved! Go to Solution.
This can be easily done by crosstab tool and dynamic rename
1. Cross tab tool key as Name, name as Date and value as free hours.
2. Dynamic rename tool to replace "_" to "/"
Hope this helps🙂
Yeah thats exactly what i needed, didnt even had to use the Dynamic Rename with my project tho
Thanks buddy