Discussion Board for collaboration on QlikView Scripting.
We are having following type of records in our database under department fields. Now we want to replace this file with CSG and MKTG wherever text is appear as CSG and Marketing.
Hi If I understand correctly you want to replace Baroda-CSG with CSG and Marketing-Baroda with Marketing.
You can use substringcount function.
If(SubstringCount(Field,'Marketing')=1,'Marketing',Field)) as aa
Hope this will help
Please Find Attachement .Check this correct or not.
Not exactly sure of your requirements so choose one of these in your load script:
Replace(Department,'Marketing','MKTG') AS Department
(ooxml, embedded labels, table is Sheet1);
IF(Department='CSG and Marketing','CSG and MKTG',Department) AS Department
Hope this helps,