Hello,
I have two tables which I want to make full outer join.
One is Inbound the other is Outbound of the same orders. Since after inbound the orders are places in stock, and waiting for the time to be dispatch and got a record in the outbound table.
Inbound:
| Order | | Dateinbound |
| 1 | | 01.01.2021 |
| 2 | | 01.01.2021 |
| 3 | | 03.01.2021 |
| 4 | | 04.01.2021 |
| 5 | | 04.01.2021 |
| 6 | | 01.01.2021 |
Outbound:
| Order | | Dateoutbound |
| 1 | | 30.01.2021 |
| 2 | | 05.01.2021 |
| 3 | | 17.01.2021 |
| 4 | | 24.01.2021 |
5 | | 19.01.2021 |
6 | | null |
After the join:
| Order | | Dateinbound | Dateoutbound | |
| 1 | | 01.01.2021 | | 30.01.2021 |
| 2 | | 01.01.2021 | | 05.01.2021 |
| 3 | | 03.01.2021 | | 17.01.2021 |
| 4 | | 04.01.2021 | | 24.01.2021 |
| 5 | | 04.01.2021 | | 19.01.2021 |
| 6 | | 01.01.2021 | | null |
After joining them I want to unpivot the Inbound and Outbound dates to bring them into a format that I can filter and count in the same columnn. But the problem for order no. 6 is that after unpivoting, it exist only for inbound but not for outbound. Is there a way to keep the Nulls?
| Order | | Date | | Type |
| 1 | | 01.01.2021 | | Dateinbound |
| 2 | | 01.01.2021 | | Dateinbound |
| 3 | | 03.01.2021 | | Dateinbound |
| 4 | | 04.01.2021 | | Dateinbound |
| 5 | | 04.01.2021 | | Dateinbound |
| 6 | | 01.01.2021 | | Dateinbound |
| 1 | | 30.01.2021 | | Dateoutbound |
| 2 | | 05.01.2021 | | Dateoutbound |
| 3 | | 17.01.2021 | | Dateoutbound |
| 4 | | 24.01.2021 | | Dateoutbound |
| 5 | | 19.01.2021 | | Dateoutbound |
| 6 | | null | | Dateoutbound |
Thank you very much in advance.
Best.
