ETL - Pivot

[yrstruly]

My data source is Google Campaign Manager and my destination Google Bigquery. Is it possible in Talend to take data from the source(see: https://docs.google.com/spreadsheets/d/1-9x4ean4QleYODvu8GsAsgm8OKVjABeM/edit?usp=sharing&ouid=10412...).

Convert columns from W in the Data Sheet to Pivot tables. Split row W into five columns like this(https://docs.google.com/spreadsheets/d/1USp5J10-If_gOC3s_j-wxKeha-gLEEDI/edit?usp=sharing&ouid=10412...😞 and also, assign unique primary keys?

CM Data table is split into 2.

[Anonymous]

You are asking for a complete solution here. It is very hard for people to understand a requirement like this. You really need to break it down into much smaller sub-questions and ask about those individually providing as much detail as you can. This certainly looks possible, but it is too much to ask in one question.

[yrstruly]

I would like to convert this data(see data tab:) https://docs.google.com/spreadsheets/d/1-9x4ean4QleYODvu8GsAsgm8OKVjABeM/edit#gid=1617823044

to a pivot table as like this(see tab bq-result): https://docs.google.com/spreadsheets/d/1USp5J10-If_gOC3s_j-wxKeha-gLEEDI/edit#gid=1493175260