topic Re: How to multiple replace into single replce funcation in QlikView

How to multiple replace into single replce funcation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am Qlikview learner..\

My expression like below..

Replace(Replace(Replace(Replace(Replace(Replace(Replace([Meeting Type Code],'GRP','Group Meeting'),'CCL','Conference Call'),'DINNER','Dinner'),'LUNCH','Lunch'),'BREAKFAST','Breakfast'),'GBR','Break'),'DINE','Dinner') as [Meeting Type Code]

How to Write single replace or any other way is there..

Thanks,

Nagarjuna

Re: How to multiple replace into single replce funcation

Anil_Babu_Samineni — Tue, 16 Jan 2018 12:16:10 GMT

May be this?

Pick(Match([Meeting Type Code], 'GRP', 'CCL', 'DINNER', 'LUNCH', 'BREAKFAST', 'GBR', 'DINE'), 'Group Meeting', 'Conference', 'Dinner', 'Lunch', 'Breakfast', 'Break', Dinner') as [Meeting Type Code]

Re: How to multiple replace into single replce funcation

teempi — Tue, 16 Jan 2018 12:19:59 GMT

Hi,

Based on the example I think you should take a look at the Applymap() function. It seems you want to convert values to different values, not just replace a few characters. Something like this should do the trick:

MeetingTypeCode_MAP:

MAPPING LOAD * INLINE [

OriginalCode, ReplacementCode

GRP, Group Meeting

CCL, Conference

DINNER, Dinner

LUNCH, Lunch

BREAKFAST, Breakfast

GBR, Break

DINE, Dinner

];

Then in your load statement you can use this:

LOAD

...

Applymap('MeetingTypeCode_MAP', [Meeting Type Code], 'Unknown') AS NewMeetingTypeCode

...

-Teemu

Re: How to multiple replace into single replce funcation

Anonymous — Tue, 16 Jan 2018 13:15:40 GMT

Thank you!!!!!!

Re: How to multiple replace into single replce funcation

Anil_Babu_Samineni — Tue, 16 Jan 2018 13:38:45 GMT

NP, Please close this thread Qlik Community Tip: Marking Replies as Correct or Helpful