Data Load - Scientific format of field

[Nick_72]

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?

[Vegar]

you could try setting a format to text when loading. 

something like this:

Load

text(MSMOVEMENT_LABEL_FKEY) as MSMOVEMENT_LABEL_FKEY,

...

[Joseph_Musekura]

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