Skip to Content
avatar image
Former Member

Fix value with if statement


I'm new on PI mapping, and I have some requirement to do the below:

If "code" node equal "fix values" return all table columns ( multiple nodes)

if "code" node not equal "fix values" return (sub of table columns)

* In Second condition, I have option to replace fix values with a predefined value "000".

My attempts as below:

code >fix values > equalsS > Not > If > extra...

constant "000" > equalsS >

constant "000" > then

Once I have tried to display queue for the first part, I got " cannot cast "000" to Boolean "

I used "equalsS" since all fixed values are not numeric values.

Can you please assist me how I can resolve the error message, and what is the best way to insert all or sub of table columns?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers