Floating Decimal
I am trying to connect to data sets together, but I continue to get the message of remove 1 column, Budget DH TTH: Floating Decimal, after run the preview, but in my preview, I see there is a floating decimal. I also try to add it in the alter columns, but it still doesn't fix it. Any ideas?
Best Answer
-
That is expected, when you Append 2 files, at the end you need a consolidated set of columns that will remain in the appended version, this means if they do not have the same columns, like in your case, that one of the following will happen to 1 or more of the original sources being appended:
- Columns will be deleted usually when the Columns to include in the Append is set to one of the sources, this is the original scenario you showed.
- Columns will be added usually when the Columns to include is set to Include all columns which is what you're seeing in the second attempt.
If neither of these is what you're looking for, you'll need an Alter Columns to rename them in a consistent way across the ones being appended, or perhaps you're not looking to append (which is adding the rows from multiple datasets together in a single list) but to join (which is adding columns from multiple datasets together into "merged" rows).
0
Answers
-
in option 1 in the alter columns you select which dataset to use to define the columns. If you want all columns selected change this to All columns
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thank you. That still didn't work. I have two different files I am trying to append, so maybe that is the issue, they do not have the same columns.
Below is the latest screenshot.
0 -
That is expected, when you Append 2 files, at the end you need a consolidated set of columns that will remain in the appended version, this means if they do not have the same columns, like in your case, that one of the following will happen to 1 or more of the original sources being appended:
- Columns will be deleted usually when the Columns to include in the Append is set to one of the sources, this is the original scenario you showed.
- Columns will be added usually when the Columns to include is set to Include all columns which is what you're seeing in the second attempt.
If neither of these is what you're looking for, you'll need an Alter Columns to rename them in a consistent way across the ones being appended, or perhaps you're not looking to append (which is adding the rows from multiple datasets together in a single list) but to join (which is adding columns from multiple datasets together into "merged" rows).
0 -
Thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 620 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 742 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive