Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

Handling numbers stored as text, and length exceeding 16 digits

Handling numbers stored as text, and length exceeding 16 digits

3 Replies
giakoum
Honored Contributor II

Re: Handling numbers stored as text, and length exceeding 16 digits

Re: Handling numbers stored as text, and length exceeding 16 digits

use the text() function in your load script to force the data to be treated as text.

Load

     text(field1) as field1,

...

from ...

Not applicable

Re: Handling numbers stored as text, and length exceeding 16 digits

try this:

num(left(Field,13))