ETL Append Rows Not Matching Identical Columns...
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.
- 10.6K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board