I am trying to create a If statement for part numbers, I want only part numbers the have wildcard which I believe is * and the letters HR. I have tried the below:
IF [Item (MCN)] ENDSWITH("*HR") THEN TRUE END
IF [Item (MCN)] CONTAINS("*HR") THEN TRUE END
IF [Item (MCN)] ENDSWITH("TR") THEN NULL END ( I tried to remove all the TR part numbers)
Any help would be greatly appreciated, I am still learning as I go. Headfirst!
There's no need to use * for the wildcard, so it should be:
IF ENDSWITH([Item (MCN)],"HR") THEN 1 END
IF CONTAINS([Item (MCN)],"HR") THEN 1 END
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...