Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Cannot merge two data sets with added column.

Received Response
21
Views
2
Comments

Summary

Cannot merge two data sets with added column.

Content

Dears,

I have two sample data sets:

 

Dataset1:

Dataset1.PNG

Dataset2:

Dataset2.PNG

 

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:

Data Flow.PNG

 

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?

 

How can we otherwise achieve the required outcome - simply merge the two above data sets?

 

Best regards,

Pawel.

Answers

  • Rank 4 - Community Specialist

    Hi again, Pawel! Have you tried using an Aggregate step in the initial dataflow after you've added the column. You can choose whether the column is a measure or an Attribute. Please will you try that and then let me know how it goes, and i'll look into other things if it doesn't work? You can also try adding a CAST function into the "Add Column" formula to set the datatype - e.g. CAST(*column name* As numeric) and that will set the data type for that column!

  • Rank 4 - Community Specialist

    Hi,

    In the end - I have managed it differently.

    Basically, in my Dataset 2 I have set the 'Counter' column as text. Then during dataflow adding a new column works as expected. In the resulting dataset I'm changing the 'Counter' column back into number.

    Not super elegant but it works for me.

    Hope it helps,

    Pawel.

Welcome!

It looks like you're new here. Sign in or register to get started.