Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Cannot merge two data sets with added column. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cannot merge two data sets with added column.

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 2 comments


Cannot merge two data sets with added column.



I have two sample data sets:





As You can see the only difference is the second dataset has an extra column with a Type: Number and Attribute: Measure (Counter).


I'm trying to do a simple merge using a Data Flow:


In a merge the number and types of columns needs to match so I'm adding a column in Dataset1 named "Counter" which exists in Dataset2. However, no matter what type/attribute for the Counter column in Dataset2 I choose - I always get the error above.


Is there any way to set the attribute/type of the column being added in the data flow?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!