Limit to CSV Import to Qlikview

[craig157]

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

[Peter_Cammaert]

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.

[martinpohl]

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

[Peter_Cammaert]

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...