Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Christopher,
Try loading the application number like this:
LOAD [Drug Name],
[Drug Code],
Text(ApplicationNumber) as ApplicationNumber
FROM
...;
Hi Christopher,
Try loading the application number like this:
LOAD [Drug Name],
[Drug Code],
Text(ApplicationNumber) as ApplicationNumber
FROM
...;
try with
excel:
LOAD [Drug Name], [Drug Code], text(ApplicationNumber) as ApplicationNumber
FROM tblWarehouseDrugList.xls (biff, embedded labels, table is tblDrugFile$);
I get this
Thank you very much, it is now working fine
Thank you very much
Thank you very much it is now working fine
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
Thank you
You're welcome
regards
Marco