Import without clear 0 on left

Mon, 19 Apr 2010 15:12:18 GMT

Dear all,

i have a table that first column is a postal code (Fron diferrent countries, then lenght is variable)

I want to import to a table without clear chars 0 on left.

How can i do that

Example

Table 1

00080 -> imports 80 and I want 00080

00000080 -> Imports 80 and I want 00000080

Thanks for your help

Miguel_Angel_Baeyens — Mon, 19 Apr 2010 15:20:56 GMT

Hello Jordi,

As they are not numbers (because you are not going to operate with them) try the following in your loading script:

Text(Postal Code) AS Postal Code

It will leave zeroes in the values.

Regards.

topic Import without clear 0 on left in QlikView