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
14
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!