topic Re: Datamodel Help in QlikView

Datamodel Help

santharubban — Wed, 22 Oct 2014 16:29:42 GMT

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.

Re: Datamodel Help

its_anandrjs — Wed, 22 Oct 2014 16:36:35 GMT

Your output not understood can you explain more about that.

Regards,

Anand

Re: Datamodel Help

santharubban — Wed, 22 Oct 2014 16:49:38 GMT

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.

Re: Datamodel Help

Anonymous — Wed, 22 Oct 2014 16:52:13 GMT

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).

Re: Datamodel Help

albertovarela — Wed, 22 Oct 2014 17:03:32 GMT

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);

Re: Datamodel Help

its_anandrjs — Wed, 22 Oct 2014 18:53:32 GMT

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