Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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