Error while finding and replacing NULL Values?

Question

question

Ankur A3 asked Jul 28, '22 Ankur A3 commented Jul 28, '22

Error while finding and replacing NULL Values?

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!

Software Version:

FlexSim 21.0.10

flexscript null values replacement

1658991110312.png (20.9 KiB)

28072022-replacing-null-values.fsm (29.0 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2022-07-28T09:08:11Z

Felix Möhlmann answered Jul 28, '22 Ankur A3 commented Jul 28, '22

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.

1658999264077.png (10.1 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ankur A3 commented · Jul 28, 2022 at 01:30 PM

Thank you! @Felix Möhlmann

Understood well.

0 ·

question