Basic Load from CSV lead to incorect data, problem with leading zeros

[retko1985]

Hello,

please see attachments,

here is my csv:

Notice that Country CH has 0002, but Country NL has 2 (not 0002).

After load I get:

Drives me a little nuts

Can someone help me please?

Thanks

[Frank_Hartmann · Accepted solution]

try this:

Directory;
LOAD A1, 
     B1, 
     text(C1) as C1
FROM
C:\Users\admin\Desktop\Zeros1.csv
(txt, utf8, embedded labels, delimiter is ',', msq);

[stabben23]

Hi,

this is not related to csv, its Qlikview Standard.

Qlikview remember the first read format, here 0002, then when 2 is read, Qlikview is so "smart" that he "convert" this to 0002. If you read 2 first, then CH value will get 2 also, try if you dont belive

So if you do as Frank mention, then It will Works for you.