Skip to main content

Folks,

I have reviewed the questions with similar key words and try as I might I can't get a result. I suspect syntax or upside-down logic is the issue. I have been using conditional syntax all over my workspace so I know the basics.

It's a classic output value after testing another field. However the test is a little backward.

If Type IN "AB","BC","CD" NO OUTPUT

Else OUTPUT size

So my criteria is rejection criteria rather than acceptance criteria. The issue is it seems to be getting completely ignored. I have reduce the IN to a single known Type and still no result.

I have modified the syntax to include\\not include double quotes, single quotes, no quotes, taking care to remove white spaces, brackets ()

Perhaps I'm using the wrong transformer in the wrong place.

Advice appreciated.

Sorry folks. Rookie mistake. "No Action" is not the same as NULL

 

 


You can find the description of the different operators here


Reply