Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
DEAR TEAM,
We are facing an issue in production where not all rows of tab delimited text file are getting loaded inside qlikview.
IF FOR EXAMPLE FILE HAS 1000 ROWS ONLY 500 GETTING LOADED AND THERE IS NO ERROR ALSO AND AT TIMES IT GIVES ERROR AS" File extdata.cpp, Line 2903""
Format of the data is attached in sample.
A)ONE WHERE ROWS ARE LOADED
B_ONE WHERE ROWS ARE NOT GETTING LOADED.
read that "msq"" or ""no qoutes"" can be used but I don't think this is causing an issue.
Pease guide and advise.
Dear Toni,
After replacing the syntax to "no quotes"" it worked and loaded all rows "". Ignoring the missing closing quotes.
Now by default we are using "msq"" in load script.Doe sit mean that I nned to change in every place of loading script.
What will happen if the data sets contains quotes of field values ?will that be ignored or skpiied?
Most likely you should. It depends on if the data contains quotes or not. The load statement should have a setup that matches you data.
