Left Join or Mapping

[bharatkishore]

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

[arvind_patil]

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]

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]

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]

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

Thanks,

Arvind Patil