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
I have to find all matching for column “MATICNI_BROJ” from second table
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”.
If you try to put a condition before doing the lookup? Such as “If the number is not empty, then I do the lookup”?
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?
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.
Please tell me if this resolves your issue.