Moving a data field between connected tables

[matthewlau120]

Hi all,

Since I am not so familiar with the joining feature. My question is about how can I move the column "Product typ in english" from Product Master table to sales_details table. The purpose of this move is because of I need "Product typ in english" field in sales_details table for further calculation. I have tried to use lookup and outerjoin but thats not what I expected

[Somasundaram]

Hi,

 here we no need to move field to sales details table since, it's already associated with Product master table.

If you want to move , Using Mapping load and Applymap() we can move to fields.

add the below script

Protype:

Mapping load

sales_details_desc2,

Product typ in english

from Product master table;

Sales detailstable:

Applymap('Protype',sales_details_desc2,'n/a') as  Product typ in english

[AshutoshBhumkar]

Hi,
You can use Join, Applymap().
Since you have tried Outer join, let us know the expected output with an example.

Regards,
Ashutosh