Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hamza99a
Creator II
Creator II

data load not working

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!

1 Solution

Accepted Solutions
hamza99a
Creator II
Creator II

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

Thanks for your help

View solution in original post

4 Replies
hamza99a
Creator II
Creator II

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

Thanks for your help

View solution in original post

balabhaskarqlik

That's a good try.

balabhaskarqlik

LOAD *

FROM  [..\myproduct.csv] 

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