topic Scripting - add record if key is not present in QlikView

Scripting - add record if key is not present

zagzebski — Wed, 30 Jul 2014 12:57:15 GMT

I have two tables :

Table 1:

Key

Reason

Table 2:

Key

Reason

I want to write a script that would concatenate Table 2 (into Table 1) ONLY when the key in Table 2 is not present in Table 1.

Thanks in advance for any help.

MK_QSL — Wed, 30 Jul 2014 13:04:46 GMT

Table 1:

Load

Key

Reason

From TableName....

Concatenate

Table 2:

Load

Key

Reason

From TableName

Where Not Exists(Key)

its_anandrjs — Wed, 30 Jul 2014 13:05:25 GMT

Try with Where NOT Exists statement

The below is example load script for understand how it works

Ex:-

Table1:

LOAD * Inline

[

Key,Reason

1,N

2,Y

];

Concatenate

Table2:

LOAD * Inline

[

Key,Reason

3,Y

] Where not Exists(Key);