Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
matthewlau120
New Contributor

Moving a data field between connected tables

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 expectedScreen Shot 2019-01-23 at 5.19.51 PM.png

 

Labels (3)
2 Replies
Somasundaram
Contributor III

Re: Moving a data field between connected tables

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

 

 


-Somasundaram
Partner
Partner

Re: Moving a data field between connected tables

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

Regards,
Ashutosh