Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Joins between two date dimensions
Claudia Ogrezeanu-Oracle
Rank 2 - Community Beginner
Hi all,
I have one file which contains the following:
Open order month// Open orders
Jan 2021 // 400
Feb 2024 // 100
Another one for closed orders:
Closed order month// Closed orders
Jan 2021 // 100
I am trying to get the following output:
Month // Open // Closed
Jan 2021 // 400 // 100
Feb 2024 // 100 // 0
I tried creating duplicate files, as the data was in one table only, and used full outer join - it does not work properly.
What other suggestions do you have?
Regards,
C
0
Answers
-
Isn't this the exact same thing as your other thread? (despite you deleting the content of the question…)
I assume your "orders" are just like the SRs you were trying to analyze in the other thread. Or how is this one different? (Because you marked the other one as answered.)
0
This discussion has been closed.