topic How to rename field values in Qlik via Load Editor in App Development

How to rename field values in Qlik via Load Editor

DJ21 — Tue, 13 Dec 2022 04:13:11 GMT

Hello All,
I would need to change some field value in qliksense.

For example
One Column Heading is "Threshold Limit". It is having 2 values.
1. <Limit

2. <Limit

Need to change these field Name
1. "<Limit" to "UnderLimit"

2. ">Limit" to "OverLimit"

Kindly suggest
Many thanks

Re: How to rename field values in Qlik via Load Editor

RsQK — Tue, 13 Dec 2022 06:40:28 GMT

Hi, I'd go with mapping. Try this:

[ML_THRESHOLD]: MAPPING LOAD * INLINE [ From,To <Limit,UnderLimit >Limit,OverLimit ]; temp: LOAD ROWNO() AS Row, "Threshold Limit" INLINE [ Threshold Limit <Limit >Limit ]; final: LOAD Row, APPLYMAP('ML_THRESHOLD',"Threshold Limit") AS "Threshold Limit", "Threshold Limit" AS "Threshold Limit Original" RESIDENT temp; DROP TABLE temp;

Re: How to rename field values in Qlik via Load Editor

MayilVahanan — Tue, 13 Dec 2022 07:17:09 GMT

Simply go with if statement, try like below

Load *, If("Threshold Limit" = '<Limit', 'UnderLimit', 'OverLimit') as FieldName from urdatasource;

Re: How to rename field values in Qlik via Load Editor

jagadeeshbv29 — Tue, 26 Sep 2023 11:34:40 GMT

not working

Re: How to rename field values in Qlik via Load Editor

MayilVahanan — Wed, 27 Sep 2023 01:41:54 GMT

can you provide the sample data to verify?

Re: How to rename field values in Qlik via Load Editor

anat — Wed, 27 Sep 2023 02:27:35 GMT

Load *, If(left("Threshold Limit",1) = '<', 'UnderLimit', 'OverLimit') as FieldName from urdatasource;