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

qlik4asif — Sat, 16 Nov 2024 21:05:16 GMT

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 🙂

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

Vegar — Tue, 09 Apr 2019 16:49:10 GMT

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;

topic Re: how to split the values in a columns and map with the existing field in a datamodel in App Development

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

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