How to multiple replace into single replce funcation

[Anonymous]

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

[Anil_Babu_Samineni]

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]

[teempi]

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

[Anonymous]

Thank you!!!!!!

[Anil_Babu_Samineni]

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