More that 14 digits numbers in Qlik leads to exponential representation, that could probably causing you the issue for precision correctness. You can load them as text using text() and that should be a problem since these are agent number and you probably are not going to perform any math cal on it.
Thanks! Loading as TEXT did the work. However, next I want to left join these agent names based on policy numbers with another table. How should I convert these policy numbers back to numbers, so that left join works?
