Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Can anyone confirm if there is a limit to how many columns Qlikview can import from an excel document?
I've got a spreadsheet I am uploading which has 112 Columns and it always fails on the 100th column if I delete some of them.
Thanks,
Craig
If you cannot share your data, reduce the content of your source file to a few lines only and retry. If the problem goes away, you're having issues with the formatting of your source file.
BTW CSV is not the same as "Excel file". Excel files are usually binary or strictly formatted, while CSV files are text files with a monstrous range of possible formatting issues. We try to figure out whether it's a formatting problem that is causing issues here. And that is awfully difficult to spot while effectively being blind.
please check the name of your columns.
There is a problem if the name is equal to a Qlik command like
date, left, num
Then you have to set the column name in script in "
example
load
"date",
invoiceNo,
value......
regards
Which version of QV are you running? LOAD statements shouldn't exhibit that behaviour as the load script language has no reserved words. So it must have changed somewhere along the road.
A SQL SELECT on the other hand...