topic Re: data load not working in App Development

data load not working

hamza99a — Thu, 30 Aug 2018 12:51:35 GMT

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!

Re: data load not working

BalaBhaskar_Qlik — Thu, 30 Aug 2018 15:57:44 GMT

Check this:

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

Re: data load not working

hamza99a — Fri, 31 Aug 2018 16:26:56 GMT

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

Thanks for your help

Re: data load not working

BalaBhaskar_Qlik — Fri, 31 Aug 2018 16:29:54 GMT

That's a good try.

Re: data load not working

BalaBhaskar_Qlik — Fri, 31 Aug 2018 16:32:29 GMT

LOAD *

FROM [..\myproduct.csv]

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