topic Re: How can I load a field based on the value in a second field? in QlikView

How can I load a field based on the value in a second field?

jwheatonumich — Wed, 25 Nov 2020 16:16:04 GMT

I have the following data source:

I would like to load the following table into QlikView:

Product	Parent	Price	Parent Price
Product A		1
Product B	Product A	2	1
Product C		3
Product D	Product A	4	1

I can't figure out how to load the parent price field. Any help would be greatly appreciated.

ychaitanya — Tue, 03 Apr 2018 20:56:16 GMT

you can try like this

Prod_Price_Map:

Mapping Load Product, Price

from Source_Table;

FACT:

Product,

Parent,

Price,

ApplyMap('Prod_Price_Map',Parent) as Parent_Price

from Source_Table;

uacg0009 — Wed, 04 Apr 2018 03:09:19 GMT

Hi Heaton,

I think a "left join" can make this happen. like:

table1:

LOAD * INLINE [

Product, Parent, Price

Product A, , 1

Product B, Product A, 2

Product C, , 3

Product D, Product A, 4

];

Left Join

LOAD Product as Parent,

Price as [Parent Price]

Resident table1;

Result is what you want.

Thanks.

Aiolos