Say I have a BO report build on 2 queries.
Both of these queries hold a field with the same name, say Cost Center (one query is a universe other query an excel sheet).
Now I need to come up with some sort of check mechanism.
The BO report will give more cost centers then we have in query 2 the excel sheet.
This is all Ok I just want to know what Cost Center are in Query 1 that are not in Query 2 because I have to exclude these cost centers in the Query filter for next runs.
In excel you would do a vlookup or match from 1 sheet in the other sheet.
How would this work in BO?
rpinxt (BOB member since 2019-01-23)