Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to figure out how to remove all rows of customer number that starts with "C0". Where customer Number is my Key Joining field with other tables.
I need them gone
You need solution at script level or UI level?
In the where clause try Mid(Text([Customer Number]),1,1) <> 'C'
try this
Load*
from table where wildmatch(Field,'*c*')<>1
UI level would be great.
Thanks
in your measure:
do as follow:
sum({<CustomerNumber=-{"CO*"}>}YourMeasure)
try this
add in UI:
=count({<CusstNum-={"CO *"}>} Number)
Try this,
=IF(wildmatch(CURRENCY,'*CO')<>1, CURRENCY)