Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears
I write below expression for my list box , the issue is that I want to rename some of my fields name.
how can it possible to change them in expression directly?
expression :
=if(Match(Area_Category,'DCB','EServices','EB','Game','Lifestyle','Money_Collection','Sport','Streaming','Traditial'),Area_Category)
Items that I want to
change:
'DB' >>> 'DEDICATED C'
'Money_collection' >> 'M Col'
You can create a synthetic dimension using ValueList ().
For instance: ValueList('DEDICATED C','EServices','EB','Game','Lifestyle','M Col','Sport','Streaming','Traditial')
The problem here is that you have to apply valuelist in your expressions too.
You could also use Replace() function. I guess it's better option than above one. For example: Creating a master dimension like this:
If(Match(Area_Category,'DCB'),Replace(Area_Category,'DCB','DEDICATED C'),Area_Category)
But, of course, you strongly recommend you replace field value while scripting. Then you can use Mapping table and so on.
Cheers
Works perfectly! Thank you!