Cannot merge two data sets with added column.
SummaryCannot 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?