Table values

[Chanin]

Hello Qlik Experts,

Suppose There are 2 Tables:

Table1:

Load * Inline[

Field

1

2

3];

Table2:

Load * Inline[

Field

3

4

5];

I want the output as 

Field

1

2

Just the unique Field values of the first table (Table1:) 

[I want the result where either Keep, Join, Concatenate or Exists or a combination of them ]

Thanks in advance.

Regards

[Kushal_Chawda]

@Chanin  try below

Table2:
Load * Inline[
Field
3
4
5];

Table1:
NoConcatenate
Load * Inline[
Field
1
2
3] where not Exists(Field);

DROP Table Table2;

[Chanin]

Hi,

Thanks a lot for taking the time to reply. However is it possible to achieve this solution without changing the position of the tables

[Kushal_Chawda · Accepted solution]

@Chanin  why you don't want to change the position of table? There is always better way to do it. Keeping position same will require to load table twice  as below

Table1:
Load * Inline[
Field
1
2
3];

Inner Join
Load * Inline[
Field
3
4
5];

Table1:
NoConcatenate
Load * Inline[
Field
1
2
3] where not Exists(Field);

DROP Table Table1;

[Chanin]

This Gives the Answer

Field

1

2

3

[Kushal_Chawda]

@Chanin  did you drop the initial joined  table?

DROP Table Table1;

[Chanin]

yup, Sorry didn't drop the table. thanks a ton for your help