Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial Reload - exact syntax

I have a file with the following code:

LOAD

ADD LOAD

$(vMapExpr(KEYWORDS)) as MSRREFNO,

$(vMapTwo(KEYWORDS)) AS WILDWORD,

NUM(LEFT(HSCODE,8)) AS D8HS,

NUM(LEFT(HSCODE,8)) AS HSDUTY8,

NUM(LEFT(HSCODE,6)) AS D6HS, *;

RECORDS:

SQL SELECT

//TOP 10000//use this line when you want a fast reload to test new data or formula

RECORDID,

BN,

LINEID,

et

etc.

but this just adds all the old records on top of the existing ones. The manual is no help, since as usual, the examples are incomplete. Can someone please show the EXACT syntax for a LOAD statement followed by a SQL SELECT? 

1 Reply
Not applicable
Author

Please note - there is no first LOAD statement in the example above. I can't edit my post. It should just read "ADD LOAD"