topic ETL - Pivot in Talend Studio

ETL - Pivot

yrstruly — Fri, 15 Nov 2024 23:06:14 GMT

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=104129043494164133703&rtpof=true&sd=true).

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=104129043494164133703&rtpof=true&sd=true😞 and also, assign unique primary keys?

CM Data table is split into 2.

Re: ETL - Pivot

Anonymous — Tue, 22 Mar 2022 02:04:11 GMT

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.

Re: ETL - Pivot

yrstruly — Thu, 24 Mar 2022 07:55:29 GMT

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