Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 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
Ability to union unmatched columns in a data flow
MJC
Rank 4 - Community Specialist
If I have two datasets in a data flow and dataset 1 has 20 fields, and dataset 2 has 25 fields, and 18 of those columns match, then only 18 get unioned in the resulting dataset. It would be great to be able to include the unmatched columns in the output as well, rather than having to create dummy fields in the branches of the data flow to get those unmatched fields to be included.
2
Comments
-
Would you want those extra columns filled with nulls, or something else? @MJC
0 -
@GabriellePrichard-Oracle nulls would be great
0
