Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to update my data at Qlik level where ever we have word 'plant' should be 'Centres'.
Any suggestion. i tried Replace function. it didn't work out.
For example:
Field1
Plant packaging
Covered plant
Output
Centres packaging
Covered Centres.
Thanks
Manish Madan
Capitalize(Replace(lower(Field1),'plant','Centres'))
Capitalize(Replace(lower(Field1),'plant','Centres'))
You can try MapSubString function -> MapSubstring ‒ QlikView
Help section provides an example: