Changing Heading's in Dimentions

[mohiahmed]

Dear all,

I am new to QV and still trying to figure this out and need your help.

In one of my Dimension "Processing Area" and within that I have two heading "Lending Operations and Middle Office", however  how can I change that to "MC and LC".  I have attached the screenshot which I have currently.

Your help and support will be greatly appreciated.  Also, I will be coming back for me help from the team ..

Regards

Mohi

[Peter_Cammaert · Accepted solution]

Usually this is done in the load script. You can do it in a very simple way, by adding an INLINE load like:

MapDim:

LOAD * INLINE [

Processing Area, Short Processing Are

Lending Operations, LC

Middle Office, MC

];

Or you could translate the original field values when initially loading the data using a mapping table or an IF() function call.

Best,

Peter

[vishsaggi]

As Peter mentioned you can use IF statement using Pick like:

= Pick(Match([Processing Area], 'Lending Operations', 'Middle Office'), 'LC', 'MC')

[sunny_talwar]

In general you can look here to learn how to cleanse your data

Data Cleansing

[Anonymous]

Though you have got some response already, you may try this as well with calculated dimension?

if([Processing Area]='Lending Operations','LC',

if([Processing Area]='Middle Office','MC'))

[mohiahmed]

Thank you all for your help, I did the update on load script and worked like a treat