Decimals in Input Dataset not carrying over to Output Dataset
Hi all,
I am working on creating a DataFlow as I needed to format a column from text to a date. During this process, it changed 'Net Change USD' from a Fixed Decimal to an Integer if I don't alter the column. I have altered the column to show 'Net Change USD' as a fixed decimal but it changed to just a decimal with the values still getting dropped (screenshot attached). Below is a screenshot of the column from the input and then output dataset. I also attached a screenshot of my dataflow including the formula I use for a different column incase that is causing the issue. I don't touch Net Change USD anywhere else, so I am not sure why the fixed decimal values are not carrying over.
Answers
-
Try switching to floating decimal instead of fixed.
If I solved your problem, please select "yes" above
0 -
Thank you for the quick response but that didn't fix it. Here is a screenshot of the input dataset and the output dataset. For whatever reason the data is not the carrying over correctly.
0 -
I am guessing something else is happening in your dataflow unrelated to the alter columns tile because casting the data type in the alter columns tile shouldn't cause the output you are seeing. What else is going on in your ETL? Is it just what you screenshot above? The second line (-43,413.64) going to -41,412.00 makes no sense at all - that isn't even the proper rounding.
If I solved your problem, please select "yes" above
0 -
I would have thought @ColemenWilson was on the right track. If changing the type didn't fix it, it might be causes by something in your transformations. Sometimes, applying transformations in Domo (like
STR_TO_DATE()
for date formatting) may unintentionally cause type casting issues in other columns.CAST(`Net Change USD` AS DECIMAL(10,2))
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Also, what if you scrap this ETL and instead convert your string to date in a beastmode? Using STR_TO_DATE() or I guess the same formula you are using in your formula tile?
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive