Error while finding and replacing NULL Values?

[rajankur6494]

[ FlexSim 21.0.10 ]

Hi Team,

I am assigning label based on sql query. But since all token are not meeting criteria, there are null values for label. I want to assign null values by 0. There are some errors and if condition is not working to compare null values.

Can you help me to know what is going wrong here?

28.07.2022_Replacing_NULL_Values.fsm

Thank you!

[moehlmann_fe · Accepted solution]

If the query doesn't find any rows that fit the condition, the result table is empty. So when attempting to read the first value, you get the error that there is no row 1 in the table.

Instead you should check if there are any rows in the table at all. If not, you can directly return the desired value.

[rajankur6494]

Thank you! @Felix Möhlmann

Understood well.