Full outer join while blending data

Question

Summary

Content

Hello,

Is it possible to have Full outer join when blending 2 datasets in a project in DAta Diagram view?

Thanks,

VAishali

User_6K1A3 · Answer

Happy New Year!

It is not possible to do a full outer join in the data diagram... just add facts or extend dimension.  Your best way to do a full outer join would be to create a Data Flow.  Within the data flow you have the most flexibility to join, merge and/or branch your data sets to give you exactly what you need.  These can also be scheduled and run in a sequence of multiple data flows.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/using-steps.html#GUID-A4EA2FB5-F052-4613-991C-9BF1351477CA

Brian