Row to Columns

[veekay]

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

[JosephSerpis · Accepted solution]

Hi @veekay have mocked up a workflow for you.

[veekay]

Hi @JosephSerpis 

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