Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.
what expression should i use?
thanks.
john doub
In master dimension, try:
if(wildmatch(customer,'*SHOPPER*'),NULL(),customer)
Uncheck include null values after dragging this master dimension into your table.
In master dimension, try:
if(wildmatch(customer,'*SHOPPER*'),NULL(),customer)
Uncheck include null values after dragging this master dimension into your table.
thanks very much.
that worked.