Hi I have the following scenario: DE 1:
JobID | CustomerID | Link |
---------------------------------------
123 | 122 | http://link1 |
123 | 122 | http://link2 |
123 | 122 | http://link3 |
332 | 56 | http://link1 |
332 | 56 | http://link2 |
I would like to get the data from the Data Extension above DE 1 and populate a new Data Extension with the following fields:
DE 2:
JobID | CustomerID | Link1 | Link 2 | Link3 |
---------------------------------------------------------------------
123 | 122 | http://link1 | http://link2 | http://link3 |
332 | 56 | http://link1 | http://link2 | |
Is there anyone who have experienced similar task ?