I have a sample data which I wanted to create a column but unable to do it it alteryx. Hope someone can help.
I tried transpose however it doesn't help.
Attached is the sample data. Below are the columns that I want.
i did it.
you need to
1. split the FacilityID
2. generate the header to be used in crosstab (or pivot)
3. use two crosstab. (because it actually combine of 2 different pivot)
4. join both table.
but I suspect this is a tutorial question, so i will not post any solution here.
