Datamodel Help

[santharubban]

Hi

I am using 2 tables one is Master Material and other is Batchmaterial.

Master Material:

Material	Material Text	Comp MRP Controller
10020001	ABC	B02
10020002	EFG	B03
10020003	hij	B02
10020004	klm	B04
10020005	xxx	B05
10020006	yyy	B08

Batchmaterial

Material	Material Text	BOM Component
10020001	ABC	10020004
10020001	ABC	10020002
10020003	hij	10020005
10020002	EFG	10020001

From these table i need to display here CompMPRController should be take of  BOMComponent.

Material	Material Text	BOM Component	Comp MRP Controller
10020001	ABC	10020004	B04
10020001	EFG	10020002	B03
10020003	hij	10020005	B05
10020002	klm	10020001	B03

Please advice.

[its_anandrjs]

Your output not understood can you explain more about that.

Regards,

Anand

[santharubban]

Thanks for reply..

for each material there will be different BOMcom , i want to display CompMRPcontroller correspounding to the BOMCom not to material. I want to pick the ComMRPController from thr Mastermaterial that should be based on the BOMcom in Batchmaterial table.

[Anonymous]

Please look at your 2 tables and desired output.

Your output is not possible given the two source tables. I have attached an example that I believe accomplishes your desired result (assuming that you fix your references).

[albertovarela · Accepted solution]

An apply map might be helpful; try this

Map_MasterMaterial:

Mapping LOAD

     Material,

//   [Material Text],

     [Comp MRP Controller]

FROM

  [http://community.qlik.com/thread/139128] (html, codepage is 1252, embedded labels, table is @1);

BatchMaterial:

LOAD

  Material,

     [Material Text],

     [BOM Component],

     ApplyMap('Map_MasterMaterial',[BOM Component],'N/A') as [Comp MRP Controller]

FROM

  [http://community.qlik.com/thread/139128] (html, codepage is 1252, embedded labels, table is @2);

[its_anandrjs]

Hi,

Try to load this way

[Master Material]:

LOAD * Inline

[ Material, Material Text, Comp MRP Controller

10020001, ABC, B02

10020002, EFG, B03

10020003, hij, B02

10020004, klm, B04

10020005, xxx, B05

10020006, yyy, B08 ];

[Batch Material]:

LOAD Material as [Batch Material],[Batch Material Text],[BOM Component] as Material;

LOAD * Inline

[ Material, Batch Material Text, BOM Component

10020001, ABC, 10020004

10020001, ABC, 10020002

10020003, hij, 10020005

10020002, EFG, 10020001 ];

Regards,

Anand