topic Re: Limit to CSV Import to Qlikview in QlikView

Limit to CSV Import to Qlikview

craig157 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Limit to CSV Import to Qlikview

Clever_Anjos — Wed, 10 Jan 2018 09:47:22 GMT

There´s no such limitation.

Please find attached a qvw reading more than 500 columns.

Re: Limit to CSV Import to Qlikview

Clever_Anjos — Wed, 10 Jan 2018 09:47:51 GMT

Would you mind uploading the first line of your csv file?

Re: Limit to CSV Import to Qlikview

craig157 — Wed, 10 Jan 2018 14:22:33 GMT

Hiya,

I just tried the exact script on a blank Dashboard and it seemed to work fine!

Think I am missing something somewhere...

Re: Limit to CSV Import to Qlikview

Ben_P — Wed, 10 Jan 2018 14:37:04 GMT

Sounds strange. You could try loading the file using the wizard in the script editor (insert > load statement) to see if that identifies the problem.

Re: Limit to CSV Import to Qlikview

craig157 — Thu, 11 Jan 2018 11:01:59 GMT

It is really strange! If I comment out the 100th Column, it then picks up an error on the 101th column and so on!

Re: Limit to CSV Import to Qlikview

avinashelite — Thu, 11 Jan 2018 11:22:39 GMT

share the sample file with us ...seems your missing some info here

Re: Limit to CSV Import to Qlikview

Clever_Anjos — Thu, 11 Jan 2018 11:37:21 GMT

Does your 100th have same name of another columns?

Columns into Qlik should be unique

Re: Limit to CSV Import to Qlikview

craig157 — Thu, 11 Jan 2018 11:46:27 GMT

Hi Clever,

They are all Unique.

Can't share any of the data as it contains customer details just now.

Re: Limit to CSV Import to Qlikview

Clever_Anjos — Thu, 11 Jan 2018 11:49:47 GMT

can´t you share the first header line?

Re: Limit to CSV Import to Qlikview

Peter_Cammaert — Thu, 11 Jan 2018 12:00:52 GMT

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.

Re: Limit to CSV Import to Qlikview

martinpohl — Thu, 11 Jan 2018 12:14:37 GMT

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

Re: Limit to CSV Import to Qlikview

Peter_Cammaert — Thu, 11 Jan 2018 12:25:31 GMT

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