Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Join table

hey all,

hope you can help in this kind of exercice:

here is my case >>

table 1:

ID.  Info

1.    X

2.    Y

3.    Z

4.    R

5.    N

table 2:

ID.   Info

1.    X

3.    Y

the output table needed is

output:

ID.   Info

2.      Y

4.      R

5.      N

thanks

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Try this.

Load * from table 2;

Load * from Table 1 where not exists(ID).

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
its_anandrjs

Hi,

Try this ways

Ex:-


table2:

LOAD * Inline
[
ID. ,   Info
1. ,   X
3. ,   Y
]
;

NoConcatenate
Tmp:
LOAD ID. as ID. Resident table2;
DROP Table table2;

table1:
Load ID. as IDInfo;
Load * Inline
[
ID.,  Info
1. ,   X
2. ,   Y
3. ,   Z
4. ,   R
5. ,   N
]
Where not Exists(ID.);

Regards,

Anand

Anonymous
Not applicable

WRITE THE BELOW EXPRESSION IN CALCULATION DIMENSION

=if( wildmatch(ID,'2','2'),ID,

if( wildmatch(ID,'4','4'),ID,

if( wildmatch(ID,'5','5'),ID)))