topic Moving a data field between connected tables in App Development

Moving a data field between connected tables

matthewlau120 — Sat, 16 Nov 2024 21:33:15 GMT

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

Re: Moving a data field between connected tables

Somasundaram — Wed, 23 Jan 2019 10:04:51 GMT

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

Re: Moving a data field between connected tables

AshutoshBhumkar — Wed, 23 Jan 2019 10:13:13 GMT

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

Regards,
Ashutosh