data load not working

[hamza99a]

hello all,

I have been loading in data and for some reason when qlik sense comes across a double quote it cuts off the load and only loads in a fraction of the data giving me no errors, and no keys. After removing the double quotes it loaded in all the rows. Is there anything in qlik sense that makes the load not stop when it hits a double quote?

Thanks!

[balabhaskarqlik]

Check this:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/use-quotes-in-script.htm

[hamza99a · Accepted solution]

actually the correct answer was to replace the msq in the from statement into no quotes.

Thanks for your help

[balabhaskarqlik]

That's a good try.

[balabhaskarqlik]

LOAD *

FROM  [..\myproduct.csv] 

(txt, codepage is 1252, embedded labels, delimiter is ' ', msq);