We have an issue where some of the data we are using contains string values with a leading zero (ie U.S zipcodes can start with 0 for example 01020.
in the SA app this gets parsed as a numeric value which strips off the leading 0 so it becomes 1020.
It would be great if during your parsing of the values, when checking for a numeric value to also include a check for a leading 0 and if found treat the column as a string.
Rick