Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Table 1 and table 2, what i want is i want the exact value of "D" from table 1 , publishing in Table 2. because values are same in "A,B,C" and in "X,Y,Z".
Can we use joins here? ,
or there are some different appraoch to solve this ?
Thanks & Regards,
Ranjana
Hi,
Instead of using join create a key for column A,B & C in both the tables and use Apply map.
Regards,
SK
But the columns are different, like in table 1, it has A,B,C and Table 2, it has X,Y,Z.. will it accept ?
will it work ?? if i write like:
Table 1:
Mapping Load
A,B,C
from [Lib://source/Tab1.xlsx];
Table 2:
Load * inline [ X,Y,Z]
ApplyMap ('Table 1', 'A,B,C') as D
from [Lib://source/Tab2.xlsx];