Partial Load | WebConnetor

[AlexTheTRex]

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&spreadsheet...], qvx);

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

Hope you can answer that one.

Best,

Alex

[AlexTheTRex · Accepted solution]

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 :

Spoiler

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