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: 
bharatkishore
Creator III
Creator III

Left Join or Mapping

Hi All,

I have two tables.

In one table i have A,B,C,D.....K

In second table i have A,B,C,D,L.

Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.

Now for this what i need to do join or link the tables or Mapping.. I am not sure.

Can you please help me on this.

Thanks,

Bharat

4 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Bhart,

As per my understanding you need to create composit key  and join or apply map like below:

I am using join here.

Table1:

Load

A&'_'&B&'_'&C&'_'&D as Key,

A,

B,

C,

D,

K

From Table 1;

Leftjoin(Table1)


Load

A&'_'&B&'_'&C&'_'&D as Key,

L

From Table2;


Thanks,

Arvind Patil

bharatkishore
Creator III
Creator III
Author

Hi Arvind,

left join will not  work..

i did use of mapping but i need one field category as well.

PFA app for  more ref:

bharatkishore
Creator III
Creator III
Author

You can see the attached app as well because i have used left join and the over all value is getting changed.

Please find this as well.

Can you please tell me how can i achieve it.

arvind_patil
Partner - Specialist III
Partner - Specialist III

For the time use two times apply map(Category, and L) and go ahead  will check.

Thanks,

Arvind Patil