Forum Discussion
APM
Helper I
Helper IReducing query size - querying only data in one table that also appears on all other tables
Hello. I have a 'Product' table, it has a 'Product Code' column and multiple attribute columns. It is an enormous data-set, as it has all the product a company as produced in its history. In ...
HotChilli
Community Champion
Community ChampionMaybe use List.Intersect to create a list of product codes in Inventory and Sales tables.
Then use Table.SelectRows on the Product table with List.Contains passing the list you created and the Product code.
--
I advise reducing your tables to a few rows to use as a test when writing the code