Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
As Peter mentioned you can use IF statement using Pick like:
= Pick(Match([Processing Area], 'Lending Operations', 'Middle Office'), 'LC', 'MC')
In general you can look here to learn how to cleanse your data
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'))
Thank you all for your help, I did the update on load script and worked like a treat