Loss of Data

[Anonymous]

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?

[#2 · Accepted solution]

Hi Christopher,

Try loading the application number like this:

LOAD [Drug Name],

     [Drug Code],

     Text(ApplicationNumber) as ApplicationNumber

FROM

...;

[maxgro]

try with

excel:

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

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

I get this

[Anonymous]

Thank you very much, it is now working fine

[Anonymous]

Thank you very much

[Anonymous]

Thank you very much it is now working fine

[MarcoWedel]

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

[Anonymous]

Thank you

[MarcoWedel]

You're welcome

regards

Marco