I think it depends from the fields type (numeric or string) but the only way to verify it is to connect directly to the source database and do some check.
During last year I've tried different (lots) ways to remove leading zeros and the ones i've shared is the best because it works with both numeric and string field types and it's conceptually easy to understand.
Michele De Nardi If a post helps to resolve your issue, please accept it as a Solution.
It's not reliable to use a sample file (excel,txt, csv...) instead a db source because during these exports the fields type change so the same qlik script could be returns different resuls.
Michele De Nardi If a post helps to resolve your issue, please accept it as a Solution.
