data load issue

[Mahamed_Qlik]

Hi All,

while fetching the data directly from data source connected by OLEDB ,

The data is getting change.

For example :

In my database :

Number column has values like

101

102

103

And after fetching in qlik the Number column values changed to

00101

00102

103

Automatically preceding zero is getting added.

Kindly advise.

Regards,

Mahamed

[sunny_talwar]

May be try this:

Num(FieldName) as FieldName

or

FieldName * 1 as FieldName

[idogridish2 · Accepted solution]

You need to use presiding Load and wrap the field with text function:

LOAD *,

text(Field) as Field_New;

SQL SELECT *

FROM wherever;

[sujeetsingh]

Need to format it.

Format number within expression

[Mahamed_Qlik]

Hi Sunny,

Its not gona work for me becuase i do have few text values in Number column too,

So, as the ido suggested using TEXT(FieldName) is worked out.

Thanks for your advise again.

Regards,

Mahamed