topic Re: Unable to do Transformation In Google_BigQuery in Connectivity & Data Prep

Unable to do Transformation In Google_BigQuery

Vamsi0529 — Mon, 14 Nov 2022 06:52:49 GMT

Hi Team,
I need small help, When i am trying to do transformation in Google_BigQuery_data level. I am not able to, If anyone knows please help me.

The conversationStart is a date Field
and I am getting date field in this format from Google_BigQuery_data (2022-10-29T05:45:36:641Z)

Now I want to Do transformation and need to create new date column in Google_BigQuery_data level ,I need a new column as a date in the format of 2022/10/29

[conversations]:

LOAD conversationId,
conversationStart,
conversationEnd,
originationDirection;

[conversations]:
SELECT conversationId,
conversationStart,
conversationStart as Date,
conversationEnd
FROM `Google_BigQuery_data`.conversations;

Exit Script;

When I Try to do any Transformations I am getting bellow error.

Re: Unable to do Transformation In Google_BigQuery

SankarReddyK — Tue, 15 Nov 2022 05:11:34 GMT

@Vamsi0529 , Make no changes to the select statement, instead edit the Qlik load script to suit your needs. To develop an automate script in Qlik Sense Data connection, use the select data option.

Re: Unable to do Transformation In Google_BigQuery

Vamsi0529 — Tue, 15 Nov 2022 05:29:13 GMT

@SankarReddyK

Hi Bro,

Actually i need to do thae change in select statement level only.

What out that i can't do proper incremental load.

Thanks...,

Vamsi Krishna Reddy