Forum Discussion
Solved
add custom column based on 2 different tables
Hi, I need some help; I have 2 tables with a production date and both are linked with an ordernumber. Now I would like to add a custom column; If 'table1'[ordertype] = "open" THEN 'table1'[Prod...
could you pls provide the sample data and expected output?
Table1:
| Order | Ordertype | Productiondate |
| 1234 | Queue | 26-11-2022 |
| 2345 | Queue | 28-11-2022 |
| 3456 | Open | NULL |
| 4567 | Queue | 30-11-2022 |
| 5678 | Open | NULL |
Table2:
| Order | Productiondate |
| 3456 | 29-11-2022 |
| 5678 | 30-11-2022 |
Both NULL records in 1st table should be filled with the Productiondate from the 2nd table.