Forum Discussion
Calculated column
Hello All I need your help in creating the calculated column as below. If Table 1 Product Code = Table 2 Product code and Table 1 product type 16 = “1” in (table 3 city type) then Match...
ryan_mayu - Here is how the data look like in the separate tables.
Thank you
Table 1
| Product Code | Product Type |
| 0 | 10 |
| 1 | 11 |
| 2 | 12 |
| 3 | 16 |
Table 2
| Product Code | City Code |
| 0 | AAC |
| 1 | AAE |
| 2 | AAE |
| 3 | GLE |
Table 3
| City Type | City | Country |
| 0 | AAC | AFRICA |
| 0 | AAE | AFRICA |
| 1 | AAE | MALDIVES |
| 1 | AAI | MALDIVES |
Hi,
In which Table do you want to see that calculated column? In that table, show the expected result.