how to split the values in a columns and map with the existing field in a datamodel

[qlik4asif]

Hello Experts,

I am facing a problem to integrate a table in existing data model.

I have a fact table in datamodel having one of field as Location which i am using as filter in Front End.

Eg:

Consider below is the table which i want to integrate in the existing Datamodel.

PID	CID	Location	Pprice
P1001	C1001	HYD|CHE|BNG	100
P1002	C1002	HYD	150
P1001	C1003	PUN|KER	222
P1002	C1002	GOA	300
P1004	C1004	MUM|RAJ	90

In Data model , Location Field has values like...

Location

HYD

CHE

BNG

KER

PUN

GOA

MUM

RAJ

SO first record should get highlighted when location is selected as HYD or CHE or BNG in Front end.

similarly for other records.

Please help me on this.

Thanks in advance 🙂

[Vegar]

Try this:

Load
PID,
CID,
Location as [GUI Location] ,
Pprice
From Table;

Locations:
Load distinct
Location as [GUI Location] ,
subfield(Location, '|') AS Location
From Table;