OUTER JOIN DATE DIMENSION CREATE NULL VALUE

[nhatviet]

I have two tables with no null date value. I want to union these two tables. So I decide to full outer join them

But when I use full outer join based on date dimension, it creates null value on date dimension, can you help me why this happen?

Thanks a lot, guys!

I edited the column jp_date_received name to 'date' to easily check

[cyrilastrafy]

Hello Nhatviet,

To achieve this, you can create a new dimension using COALESCE or perform a SUM operation on the two columns, depending on your specific requirements.

For detailed instructions on how to accomplish this using Looker Studio, you can refer to the following page: How to Mimic Union All Operator with Google Data Studio and Combine Sets of Data.

Best,

Cyril