topic Re: Find & Replace in QlikView

Find & Replace

Tue, 31 Jan 2012 11:43:39 GMT

Dear Sir,

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.

Ahmedabad -CSG

Baroda -CSG

CSG -BVN

CSG -Kutch

Marketing -Baroda

Marketing -Rajkot

Surat -Marketing

Regards,

UMESH

Find & Replace

vijay_iitkgp — Tue, 31 Jan 2012 11:51:51 GMT

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,'CSG')=1,'CSG',

If(SubstringCount(Field,'Marketing')=1,'Marketing',Field)) as aa

Hope this will help

Re: Find & Replace

perumal_41 — Tue, 31 Jan 2012 12:29:48 GMT

Hi,

Please Find Attachement .Check this correct or not.

Find & Replace

Jason_Michaelides — Tue, 31 Jan 2012 15:44:54 GMT

Not exactly sure of your requirements so choose one of these in your load script:

LOAD

Replace(Department,'Marketing','MKTG') AS Department

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD

IF(Department='CSG and Marketing','CSG and MKTG',Department) AS Department

FROM

(ooxml, embedded labels, table is Sheet1);

Hope this helps,

Jason