I am comparing a list of codes from two tables (Dimension Value & Award tables). As part of a data-cleanup exercise, I need to pull in the codes that don't exist in both tables. I've written the JET statement to do this. It work properly when I use the "Union" or "Intersect" function; however, I get empty results when using the "Difference" function. I am using this statement embedded within an NL Rows statement. Thanks for any help.
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Problem solved.
“The difference between two arrays consists of all of the elements that are in the first array but are not in the second”
Because in my database, the second array (sub award dimension values) is larger than the first array and contained all possible values it needed to be first. Once I changed the position of the 2 arguments (first put the dimension values array and second the award array), the function worked properly.
Please sign in to leave a comment.