https://community.qlik.com/t5/Talend-Studio/Create-Update-flow-using-bigquery/m-p/2221211#M15307 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 823px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA7T.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131194iA487E9CB0443952F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA7T.png" alt="0683p000009MA7T.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Here, I am creating the flow for insert and update. But, the difficulty in BigQuery is we can't update the values as normal like MySQL and any other Database.</P> <P>&nbsp;</P> <P>Here, what is done was If the incoming values are already in BigQuery First I delete those values by using BigQuerySQLRow.</P> <P>&nbsp;</P> <P>If I am run the job I got an error like 'No such method'.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA7Y.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146886i45746877C37AEE97/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA7Y.png" alt="0683p000009MA7Y.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Is anything wrong with this job, please let me know..!!!</P> <P>&nbsp;</P> <P>Thanks in Advance..!!!</P> <P>&nbsp;</P> Sat, 16 Nov 2024 02:37:01 GMT McJingles 2024-11-16T02:37:01Z https://community.qlik.com/t5/Talend-Studio/Create-Update-flow-using-bigquery/m-p/2221211#M15307 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 823px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA7T.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131194iA487E9CB0443952F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA7T.png" alt="0683p000009MA7T.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Here, I am creating the flow for insert and update. But, the difficulty in BigQuery is we can't update the values as normal like MySQL and any other Database.</P> <P>&nbsp;</P> <P>Here, what is done was If the incoming values are already in BigQuery First I delete those values by using BigQuerySQLRow.</P> <P>&nbsp;</P> <P>If I am run the job I got an error like 'No such method'.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA7Y.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146886i45746877C37AEE97/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA7Y.png" alt="0683p000009MA7Y.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Is anything wrong with this job, please let me know..!!!</P> <P>&nbsp;</P> <P>Thanks in Advance..!!!</P> <P>&nbsp;</P> Sat, 16 Nov 2024 02:37:01 GMT https://community.qlik.com/t5/Talend-Studio/Create-Update-flow-using-bigquery/m-p/2221211#M15307 McJingles 2024-11-16T02:37:01Z