topic Left Join or Mapping in QlikView

Left Join or Mapping

bharatkishore — Fri, 23 Feb 2018 06:22:31 GMT

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

Re: Left Join or Mapping

arvind_patil — Fri, 23 Feb 2018 08:10:18 GMT

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,

From Table 1;

Leftjoin(Table1)

Load

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

From Table2;

Thanks,

Arvind Patil

Re: Left Join or Mapping

bharatkishore — Fri, 23 Feb 2018 08:16:42 GMT

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:

Re: Left Join or Mapping

bharatkishore — Fri, 23 Feb 2018 08:30:44 GMT

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.

Re: Left Join or Mapping

arvind_patil — Fri, 23 Feb 2018 08:46:52 GMT

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

Thanks,

Arvind Patil