Hi,
I am using dblookup to get values from an ODBC database. The function works, but it returns mutiples values for the computed field. Is there a way to add additional criteria to filter further the multiple values that are returned so that I can get a single value?
Rika
Subject: dblookup Multiple Values
@Dblookup will only allow you to test on one key column. Some random thoughts:
-
If values are identical then use the Distinct option to remove duplicates.
-
If you only need the first / last then use @subset to filter these.
-
Try creating a “view” in the ODBC database that concatenates the multiple key columns from the source table in to a single column that you can dblookup against to get a single value.
-
Look at @dbcommand to specify your own Select statement that will return a single value.
HTH - Rufus.