Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi Varsha,
Yes, I am expecting similar result. Could you show the full expression.
try this
=if(WildMatch(PurgeChar(fieldname,'0123456789*'),'*CASH*'),'CASH',PurgeChar(fieldname,'0123456789*'))
if(WildMatch(TransactionType,'*CASH*'),'CASH',trim(replace(TransactionType,'*','')))
Thanks
I will come back after working.