Lookup Data Table: DoubleConverter cannot convert from (null) - how to solve

Help Studio
1

Hi. I have problem when using Lookup data table. I suppose that some empty fields causes that, but I don’t know how to solve it.

This is first table

image
image340×525 9.99 KB

I have to find all matching for column “MATICNI_BROJ” from second table
image

For those values I find matching for, I have to put it in “Uparivanje”. For others that are empty I have to put “” (empty string) to “Uparivanje”.

2

Hi,

If you try to put a condition before doing the lookup? Such as “If the number is not empty, then I do the lookup”?

Best regards,

3

But I am using lookup to find matching values in the second table for column “MATICNI_BROJ” from first table.

How can I know if column “MATICNI_BROJ” from second table is empty before lookup?

4

Hi,

Try to change the type with string, it should resolve the issue. Then you can check if the string is empty before converting it into a double (maybe you don’t need to convert it).

Therefore, the “RowIndex” property should return -1 if there is no result; maybe you can use this indicator.
image

Please tell me if this resolves your issue.

Best regards,