Skip to content

    • Magic ETL

    Magic ETL

    How to remove a decimal in an area dimension column?

    Member
    in Magic ETL

    I have a column that showing the dimensions of a unit. 5x5, 5x10, etc.. the column is in a text format and the data is coming in to Domo in a strange way, it looks like:

    image.png

    What I want is just the more standard:

    5x5, 5x10, 5x15, etc.. In the ETL how could i get rid of the .0?

    Tagged:

    Best Answer

    • Coach
      Answer ✓

      You can use the formula tile and use the replace function like this:

      REPLACE(fielname,'.0','')

      This would replace .0 with nothing which would then make it read how you want.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Answers

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories