Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi
Simply go with if statement, try like below
Load *, If("Threshold Limit" = '<Limit', 'UnderLimit', 'OverLimit') as FieldName from urdatasource;
not working
hi
can you provide the sample data to verify?
Load *, If(left("Threshold Limit",1) = '<', 'UnderLimit', 'OverLimit') as FieldName from urdatasource;