topic master dimension in App Development

master dimension

johndoub — Thu, 05 Dec 2019 21:59:23 GMT

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

Arthur_Fong — Fri, 06 Dec 2019 04:28:24 GMT

In master dimension, try:

if(wildmatch(customer,'*SHOPPER*'),NULL(),customer)

Uncheck include null values after dragging this master dimension into your table.

johndoub — Fri, 06 Dec 2019 16:11:45 GMT

thanks very much.

that worked.