Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
I guess its because some of your fields contains values like "".
If you omit the msq then it works fine!
try like this:
LOAD
Rowno() as Row,
oid,
cost,
createDate,
createdBy,
customerOrderNumber,
discount,
expiryDate,
margin,
myAddress,
myAssignedUser,
myCRMOrganisation,
myCRMSOSalesOrder,
myGTSalesPerson,
myQuoteStage,
type,
quoteNumber,
summary,
total,
mySAModule,
myCRMContact
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',');