Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am using distinct load, to get distinct agents for one policy number:
Real_agent:
NoConcatenate Load distinct
POLICY_NO_ALT,
AGENT
resident TABLE;
POLICY_NO_ALT contains policy number and AGENT names.
For some reason, distinct load is not working for very long policy numbers (15 characters).
How to get distinct values?
Best
Maasool
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.
Have a look here:
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?