Publishing one table values into another

[Ranjanac]

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 

[Saurabh_K14999]

Hi,

Instead of using join create a key for column A,B & C in both the tables and use Apply map.

Regards,

SK

[Ranjanac]

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];