number format

[tizianacaem]

Hi all,

I have a problem with the format of a number, because between the possible values i imported there are, for example 001 and 01, and they have to stay alone, but qw combines the two values and uses them as if they were only one.

There is an instruction to avoid this behavior?

Thank you

Tiziana

[boorgura · Accepted solution]

A quick solution would be to convert them to text while loading itself.

LOAD

text(<field_name>) as <field_name>

FROM <file_name>

[tizianacaem]

It does work!

Thank you for you suggest!

Bye