topic Loss of Data in QlikView

Loss of Data

Anonymous — Mon, 17 Nov 2014 19:03:31 GMT

I am importing data from an Excel file into QlikView and i am losing some data in the process. The attached Excel file is the file being imported into QlikView. For example the Drug Name Cloxacillin 250mg Capsule Application Number is being imported into QlikView as 0 instead of 00E131. What could be happening?

Re: Loss of Data

Mon, 17 Nov 2014 19:07:30 GMT

Hi Christopher,

Try loading the application number like this:

LOAD [Drug Name],

[Drug Code],

Text(ApplicationNumber) as ApplicationNumber

FROM

...;

Re: Loss of Data

maxgro — Mon, 17 Nov 2014 19:11:29 GMT

try with

excel:

LOAD [Drug Name], [Drug Code], text(ApplicationNumber) as ApplicationNumber

FROM tblWarehouseDrugList.xls (biff, embedded labels, table is tblDrugFile$);

I get this

Re: Loss of Data

Anonymous — Mon, 17 Nov 2014 19:21:30 GMT

Thank you very much, it is now working fine

Re: Loss of Data

Anonymous — Mon, 17 Nov 2014 19:24:10 GMT

Thank you very much

Re: Loss of Data

Anonymous — Mon, 17 Nov 2014 19:27:00 GMT

Thank you very much it is now working fine

Re: Loss of Data

MarcoWedel — Mon, 17 Nov 2014 22:31:58 GMT

Hi,

another possibility could be to define this variable in the script:

SET ExponentNumberNotation=0;

table1:
LOAD *
FROM [http://community.qlik.com/servlet/JiveServlet/download/658588-137794/tblWarehouseDrugList.xls] (biff, embedded labels, table is tblDrugFile$);

hope this helps

regards

Marco

Re: Loss of Data

Anonymous — Mon, 17 Nov 2014 23:29:15 GMT

Thank you

Re: Loss of Data

MarcoWedel — Mon, 17 Nov 2014 23:32:16 GMT

You're welcome

regards

Marco