Forum Discussion

juan_123's avatar
juan_123
Frequent Visitor
3 years ago
Solved

Relate two tables via three different categories (multiple relations)

Hi, I have two different tables with prices.

The first table has dates, products and expiration date.

The second table has dates, crops and a different set of expiration dates. 

 

I need to select connect both tables through each of these three variables. How can I do that?

For example. I need to compare FASt from "Aceite de soja" 4-2023 with "Soja", 1/5/2023 for the same date. How can I relate both tables to select via those categories?

 

Many thanks!
Juan

  • juan_123's avatar
    juan_123
    3 years ago

    Hi amitchandak thanks for the answer! I was just thinking about that after posting. Will try combinevalues. Thanks!