Hi
I have a data set which includes a Orderid and the order is touched by multiple marketing channels marked as interaction date 1, 2, 3.... and interaction channel 1, 2 ,3 ..... etc in one single row per order id. I would like to have a table which has the following 3 columns and the values sorted by date and respective channel:
|OrderId | Interaction Date | Interaction Channel |
Attached is the sample dataset for reference.
Thanks in advance
VK
Solved! Go to Solution.
Thanks for looking into it.
Did a couple of small changes to workflow , as one basket cannot have more than 10 interactions, so I filtered out all "null" values right after transpose and added a join on orderid (aka basket id) as well. this now works fine
VK