Convert string to number
Hi,
We have one column name "Count", in this column, we have majorly two values zero and one.
but DOMO treated this column as a string.
Could anyone know how do we convert it to an integer using the "Add Formula" method?
Thanks,
Yuvraj
Best Answer
-
One easy way in the Add Formula tile is to multiply the column by 1 like this:
"count"*1
I have used this multiple time to get a number to integer that didn't start out that way.
If you aren't doing any data cleansing along the way, you can also click on the input dataset and change the data type for that column. (This assumes there are no non-numeric values in that column). Here is a screenshot from the configuration tab of an input dataset in Magic ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
One easy way in the Add Formula tile is to multiply the column by 1 like this:
"count"*1
I have used this multiple time to get a number to integer that didn't start out that way.
If you aren't doing any data cleansing along the way, you can also click on the input dataset and change the data type for that column. (This assumes there are no non-numeric values in that column). Here is a screenshot from the configuration tab of an input dataset in Magic ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
you can't really enforce data types using add Formula.
well no that's a lie, you could use the CAST() function. If it were me though, I would use the ALTER COLUMNS tile. This way you have more granular control AND are not mixing and matching tasks. use Formulas to define formulas. use ALTER COLUMNS to set schema properties.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive