topic Re: Data Load - Scientific format of field in Connectivity & Data Prep

Data Load - Scientific format of field

Nick_72 — Fri, 01 Apr 2022 02:18:29 GMT

Hi Qlik Community

I have a problem when loading data from a txt file that values of 12 characters convert to scientific notation. See attached. any help on how i can stop this happening and just bring in the full string?

Re: Data Load - Scientific format of field

Vegar — Fri, 01 Apr 2022 04:57:12 GMT

you could try setting a format to text when loading.

something like this:

Load

text(MSMOVEMENT_LABEL_FKEY) as MSMOVEMENT_LABEL_FKEY,

...

Re: Data Load - Scientific format of field

Joseph_Musekura — Fri, 01 Apr 2022 06:25:38 GMT

Hi @Nick_72,
Please test @Vegar solution and remember to mark the answer as "solution accepted"
/joseph