Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
craig157
Contributor

Limit to CSV Import to Qlikview

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

12 Replies
Employee
Employee

Re: Limit to CSV Import to Qlikview

There´s no such limitation.

Please find attached a qvw reading more than 500 columns.

Employee
Employee

Re: Limit to CSV Import to Qlikview

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

craig157
Contributor

Re: Limit to CSV Import to Qlikview

Hiya,

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

Think I am missing something somewhere...

ben_pugh
Contributor

Re: Limit to CSV Import to Qlikview

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.

craig157
Contributor

Re: Limit to CSV Import to Qlikview

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

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

Employee
Employee

Re: Limit to CSV Import to Qlikview

Does your 100th have same name of another columns?

Columns into Qlik should be unique

craig157
Contributor

Re: Limit to CSV Import to Qlikview

Hi Clever,

They are all Unique.

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

Employee
Employee

Re: Limit to CSV Import to Qlikview

can´t you share the first header line?