Comments

1 comment

  • Avatar
    Katie Garrison

    Hi Karen,

    If all of your data with leading zeros will always be some sort of numerical string (ie there will not be values like 000{character}) you could create a custom column using the following expression in the Elasticube:

    CASE 
    WHEN Left([Values],1) = '0' THEN ToString(ToInt([Values]))
    ELSE [Values]
    END

    You might be able to do something similar with the IfInt function as well.

    Hope that helps,
    Katie Garrison | Technical Solutions Consultant

     

    0
    Comment actions Permalink

Please sign in to leave a comment.