cancel
Showing results for 
Search instead for 
Did you mean: 

Fix value with if statement

Former Member
0 Kudos

Hi

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

Accepted Solutions (0)

Answers (0)