Beast Mode string functions - converting string to number

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
1 votes

· Last Updated

Comments

  • 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.