leading zeros

[#1]

Hi:

When I load the following data from a txt file:

SKU                           Code

034000240005          15710

00034000240005      15828

The result in QV for the SKU is:

SKU                           Code

034000240005          15710

034000240005          15828

How I can fix this?

[MayilVahanan · Accepted solution]

Hi

Are you using like calculation for SKU value.. If not means, try

Load  text(SKU) as SKU,Code from tablename;

Hope it helps

[#3]

Thanks