Forum Discussion
Solved
Create table using 2 tables and a third with multipliers
Hello! I hope I can explain what im trying to attemp I have 3 tables: Table 1& Table 2 have the following structure DATE | Name | Value (date)| ID 1 | Value 1 I have many ID's w...
These are the 3 tables
| DATE | ID | Product |
| 1/1/2021 | A | 123 |
| 2/1/2021 | A | 121 |
| 3/1/2021 | A | 128 |
| 1/1/2021 | B | 243 |
| 2/1/2021 | B | 233 |
| 3/1/2021 | B | 242 |
| 1/1/2021 | C | 565 |
| 2/1/2021 | C | 566 |
| 3/1/2021 | C | 556 |
| DATE | ID2 | Product2 |
| 1/1/2021 | J | 5 |
| 2/1/2021 | J | 6 |
| 3/1/2021 | J | 5 |
| 1/1/2021 | Q | 3 |
| 2/1/2021 | Q | 2 |
| 3/1/2021 | Q | 3 |
| 1/1/2021 | M | 1 |
| 2/1/2021 | M | 1 |
| 3/1/2021 | M | 1.1 |
| ID1 | ID2 | f |
| A | J | 0.5 |
| A | Q | 0.3 |
| B | J | 0.5 |
| B | Q | 0.3 |
| B | M | 0.5 |
| C | M | 0.5 |
This is the desired output:
| DATE | ID | Product | Asoc. Prod |
| 1/1/2021 | A | 123 | 3.4 |
| 2/1/2021 | A | 121 | 3.6 |
| 3/1/2021 | A | 128 | 3.4 |
| 1/1/2021 | B | 243 | 3.9 |
| 2/1/2021 | B | 233 | 4.1 |
| 3/1/2021 | B | 242 | 3.95 |
| 1/1/2021 | C | 565 | 0.5 |
| 2/1/2021 | C | 566 | 0.5 |
| 3/1/2021 | C | 556 | 0.55 |
For example in the first row Asoc prod = 5 * 0.3 + 3 *0.3