topic data load issue in QlikView

data load issue

Mahamed_Qlik — Tue, 07 Jun 2016 11:19:26 GMT

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 — Tue, 07 Jun 2016 11:21:23 GMT

May be try this:

Num(FieldName) as FieldName

FieldName * 1 as FieldName

idogridish2 — Tue, 07 Jun 2016 11:24:55 GMT

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

LOAD *,

text(Field) as Field_New;

SQL SELECT *

FROM wherever;

sujeetsingh — Tue, 07 Jun 2016 11:28:18 GMT

Need to format it.

Mahamed_Qlik — Wed, 08 Jun 2016 05:15:35 GMT

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