Hello there,
My current setup:
In one table [ALL PRODUCTS], I have two pairs of Lookup fields, providing all the options.
[Products] = [Bananas, Apples, Grapes, Strawberries]
[Markets] = [US, FR, DE]
In another table [DELIVERED-PRODUCTS] I have multiple pairs of Lookup fields [Products] and [Markets], describing the products per market, a subset of the values in the previous table.
[Products1] = [Bananas, Apples, Grapes]
[Market1] = [us]
[Products2] = [Bananas, Grapes, Strawberries]
[Market2] = [fr]
[Products3] = [Grapes]
[Market3] = [de]
Ultimately, I would like to know what combinations are possible but not delivered per market, see point 5.
I assume this would be somehow done by concatenating all elements of one array pair with the other, as in:
[DELIVERED_Products_US] = [Bananas_US, Apples_US, Grapes_US]
[DELIVERED_Products_FR] = [Bananas_FR, Grapes_FR, Strawberries_FR]
[DELIVERED_Products_DE] = [Grapes_DE]
Same for the [ALL PRODUCTS]
[ALL_Products_Markets] = [Bananas_US, Apples_US, Grapes_US, Bananas_FR, Apples_FR, Grapes_FR, Strawberries_FR, Grapes_DE, Strawberries_DE]
Ultimately, I would like to know what combinations of products and markets are in ALL PRODUCTS and not in DELIVERED PRODUCTS.
[ALL-DELIVERED_Products_Markets] = [Apples_FR, Strawberries_DE]
Thanks a lot!