clean dimension values or categorise them

[surajap123]

Hi All,

I want to group field(dimension) values into a different dimension, ie My current field values are are not clean, so i am trying for the best way to categorize it or atleast trim the values like below example.

Field Value Example-

from-

CASH DCN2 JUL02....

CASH DCN3 JUL05...

to-

CASH

Please help me how to achieve this.

Thanks!!

[surajap123]

Hi Varsha,

Yes, I am expecting similar result. Could you show the full expression.

[arulsettu]

try this

=if(WildMatch(PurgeChar(fieldname,'0123456789*'),'*CASH*'),'CASH',PurgeChar(fieldname,'0123456789*'))

[varshavig12 · Accepted solution]

if(WildMatch(TransactionType,'*CASH*'),'CASH',trim(replace(TransactionType,'*','')))

[surajap123]

Thanks

I will come back after working.