Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
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.
For the time use two times apply map(Category, and L) and go ahead will check.
Thanks,
Arvind Patil