Greetings all!
Am trying to merge two datasets each of which result from an incoming data flow. Each dataset has a column named "Case Equivs" which is a decimal in both cases. However, when I go to Append Rows, it does not recognize that these two columns are a match and insists on adding them both or removing one or the other.
I've tried (a) ensuring their names are identical, (b) ensuring their types are identical and (c) trimming and rearranging columns so the tables are same order.
The only difference between the columns is that in one case the column is directly imported from a source csv - and in the other case the column is the result of Collapse Columns - transposing some columns into additional rows. But I wouldn't think that Append Rows would care about that transformation, right?
Thanks for any tips.