Beast Mode string functions - converting string to number

vkaul
vkaul
in Ideas Exchange

A lots of excel files received from the customers contains measures in straing format with spaces etc.It would be useful to have beast mode function that convers the string to number which can be used in the card instead of having to write Magiv ETL code to  prep the data.

1
Up
1 votes

· Last Updated

Comments

  • quinnj
    quinnj

    You can do this by the following beast mode:

     

    `string_column` + 0

     

    The "+ 0" will implicitly convert the `string_column` to a number and the result will be a number.

This discussion has been closed.

Categories