QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION

Who Me Too'd this solution

Frank_Hartmann
Master II
Master II

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 ',');

View solution in original post

Who Me Too'd this solution