Hi All,
I have a dataset looks like this.
Current Output:
AdTag_ID | Browser_ID | eventData_clickthrough_click_abcd | eventData_clickthrough_click_efgh | eventData_service_click_abcd | eventData_service_click_efgh | eventData_service_d2s_abcd |
1234 | chrome | 1 | ||||
9999 | firefox | 1 | ||||
2345 | safari | 1 | ||||
2222 | safari | 1 |
Instead of having multiple columns such as clickthrough_'abcd',clickthrough_'efgh' .... and service_click'abcd' service_click_'efgh' .... , I would like to have 3 main columns clickthrough_click,service_click and service_d2s with values such as 'abcd', 'efgh' etc.
Desired Output:
AdTag_ID | Browser_ID | clickthrough_click | service_click | service_d2s |
1234 | chrome | abcd | ||
9999 | firefox | abcd | ||
2345 | safari | efgh | ||
2222 | safari | abcd |
Thank you so much for help!
Best,
Kutay
Solved! Go to Solution.
Hi @Kutay I mocked up a workflow that produces the output you describe. Let me know what you think?
Hi @Kutay
The key here is to transpose the data first so that you can extract what you need from the headers, then cross tab it back to the orientation you need. See the attached workflow for an example.
Hope this helps!
Hi @Kenda and @JosephSerpis ,
Thank you so much for your help! I tried both of the solutions and they worked perfectly.
Best,
Kutay