How to rename field values in Qlik via Load Editor

[DJ21]

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

[RsQK]

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;

[MayilVahanan]

Hi

Simply go with if statement, try like below

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

[jagadeeshbv29]

not working 

[MayilVahanan]

hi

can you provide the sample data to verify?

[anat]

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