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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Cannot merge two data sets with added column.

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

Summary

Cannot merge two data sets with added column.

Content

Dears,

I have two sample data sets:

 

Dataset1:

Dataset2:

 

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.

Register

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