Partial Load | WebConnetor

AlexTheTRex — Tue, 13 Jul 2021 09:06:06 GMT

Hello,

Why doesn't Partial load for Google SpreadSheet Web Connector work

GoogleDriveConnector_GetSheetValues:
replace LOAD *
FROM [$(vQwcConnectionName)]
(URL IS [https://qlik.univerre.ch:5555/data?connectorID=GoogleDriveConnector&table=GetSheetValues&spreadsheetKey=xxxxxxxxxxxxxxxxx&range=Supplier+List!B5%3aAL250&valueRenderOption=FORMATTED_VALUE&dateTimeRenderOption=FORMATTED_STRING&appID=&loadAccessToken=xxxxxxxxxxxxxxxxxx], qvx);

Nothing happend when I hit the Reload Button (with partial load tick)

Hope you can answer that one.

Best,

Alex

Re: Partial Load | WebConnetor

AlexTheTRex — Wed, 14 Jul 2021 13:08:00 GMT

I found the issueS.

Do not use QUALIFY when partial reload. It broke everything Why ? I don't know, but it does.

Oh and there is also a massive issue with Mapping Load (even if not linked with the partial reload table). You should replace mapping load too. Why ? I don't know....

OHHH Finally big issue with the use of drop tables. You should using this stategies : check that blog for more info about partial reload : https://writeback.pomerolpartners.com/knowledge-base/load-script-best-practices/

EDIT, year 2043 :

Day 3484, I finally found a robust solution to avoid the partial reload nightmare:

Wrapping everything into IF statement like this :

If not IsPartialReload() then
FEATURES:
LOAD
WHAT YOU DONT WANT TO PARTIAL LOAD
FROM [lib://WhoLetTheDogsOut/WillSmith.xlsx]
(ooxml, embedded labels, table is Sheet1);
End if

If IsPartialReload() then
FEATURES:
REPLACE LOAD
WHAT YOU WANT TO LOAD
FROM [lib://WhoLetTheDogsOut/WillSmith.xlsx]
(ooxml, embedded labels, table is Sheet1);
End if

Best

Alex

topic Partial Load | WebConnetor in Connectivity & Data Prep

Partial Load | WebConnetor

Re: Partial Load | WebConnetor