I'm trying to have a table show all records from another table that aren't found in a third table. Using the image as a reference...The application is an inventory tracking app. Currently as items are scanned they are recorded in the "Scanned" table. If items are in the inventory but
are not scanned they show up in the "Missing" table. The third table I want to show all items that are scanned but not found as entries in the inventory.
So, as in the question, I'm looking for each record from "Scanned" not found in "Inventory" to be added to the currently undefined table at the end.
I figured a ForAll was my best answer but I can't seam to figure it out.
Solved! Go to Solution.
You can use the Filter function with the in operator to do that if the item can be identified by a column (such as a primary key, or an identifier). For example, if the value you're showing in your example is from a column called 'Id' in your tables, then this expression will return a table with the missing items:
Filter( Inventory, Not(Id in Scanned.Id))
You can use the Filter function with the in operator to do that if the item can be identified by a column (such as a primary key, or an identifier). For example, if the value you're showing in your example is from a column called 'Id' in your tables, then this expression will return a table with the missing items:
Filter( Inventory, Not(Id in Scanned.Id))
That was surprisingly simple. Thank you!
User | Count |
---|---|
193 | |
126 | |
89 | |
48 | |
42 |
User | Count |
---|---|
278 | |
162 | |
137 | |
81 | |
78 |