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.
