Convert string to number

user041053 · 2021-07-19T14:11:48+00:00

There was an error rendering this rich post.

user041053

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

Find more posts tagged with

Beast Mode

Accepted answers

MarkSnodgrass

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.

All comments

MarkSnodgrass

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.

jaeW_at_Onyx

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.