Magic ETL
Magic ETL
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.
Best Answer
-
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
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 - CAST(`Net Change USD` AS DECIMAL(10,2))
-
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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 745 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 67 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 46 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive