topic Re: Join table in QlikView

Join table

mario-sarkis — Thu, 18 Feb 2016 12:20:49 GMT

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

‌

Re: Join table

kaushiknsolanki — Thu, 18 Feb 2016 12:23:09 GMT

Hi Try this.

Load * from table 2;

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

Regards,

Kaushik Solanki

Re: Join table

its_anandrjs — Thu, 18 Feb 2016 12:37:55 GMT

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 ID, Info;
Load * Inline
[
ID., Info
1. ,   X
2. ,   Y
3. ,   Z
4. ,   R
5. ,   N
] Where not Exists(ID.);

Regards,

Anand

Re: Join table

Anonymous — Thu, 18 Feb 2016 13:00:14 GMT

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)))