topic Row to Columns in Alteryx Designer Desktop Discussions

Row to Columns

veekay — Tue, 06 Aug 2019 13:04:03 GMT

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

Re: Row to Columns

JosephSerpis — Tue, 06 Aug 2019 13:13:20 GMT

Hi @veekay have mocked up a workflow for you.

Re: Row to Columns

veekay — Tue, 06 Aug 2019 13:50:35 GMT

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