Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
actually the correct answer was to replace the msq in the from statement into no quotes.
Thanks for your help
actually the correct answer was to replace the msq in the from statement into no quotes.
Thanks for your help
That's a good try.
LOAD *
FROM [..\myproduct.csv]
(txt, codepage is 1252, embedded labels, delimiter is ' ', msq);