topic Re: need a help in qlik requirement in QlikView

need a help in qlik requirement

siva8 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

i have two tables like below

yesterday:

record id

today:

record id

expected output :

record id ,tag

1, old record

2, old record

3, old record

4,old record

5,new record

6,new record

can u please help me with this

thanks in advance

regards

siva

Re: need a help in qlik requirement

Stoyan_Terziev — Fri, 15 Nov 2019 08:17:47 GMT

Hello Siva,

Basically, that's a question for 'Incremental load' in qlikview.

Which can be easily achieved with the Exists() function.

Example script you can plug and play:

OldSource: LOAD * Inline [ ID 1 2 3 4 ]; JOIN (OldSource) LOAD 'old record' as tag AutoGenerate (1) ; NewSource: NoConcatenate LOAD * Inline [ ID 1 2 3 4 5 6 ] WHERE NOT Exists(ID) ; JOIN (NewSource) LOAD 'new record' as tag AutoGenerate (1) ; Concatenate(OldSource) LOAD ID,tag Resident NewSource; DROP TABLE NewSource;