Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanin
Contributor
Contributor

Table values

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

Labels (3)
1 Solution

Accepted Solutions
Kushal_Chawda

@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;

View solution in original post

6 Replies
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
Contributor
Contributor
Author

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

@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
Contributor
Contributor
Author

This Gives the Answer

Field

1

2

3

Kushal_Chawda

@Chanin  did you drop the initial joined  table?

DROP Table Table1;

  

Chanin
Contributor
Contributor
Author

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