Unable to do Transformation In Google_BigQuery

[Vamsi0529]

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.

[SankarReddyK · Accepted solution]

@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.

[Vamsi0529]

@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