Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
craig157
Creator II
Creator II

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
Clever_Anjos
Employee
Employee

There´s no such limitation.

Please find attached a qvw reading more than 500 columns.

Clever_Anjos
Employee
Employee

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

craig157
Creator II
Creator II
Author

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

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
Creator II
Creator II
Author

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

avinashelite

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

Clever_Anjos
Employee
Employee

Does your 100th have same name of another columns?

Columns into Qlik should be unique

craig157
Creator II
Creator II
Author

Hi Clever,

They are all Unique.

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

Clever_Anjos
Employee
Employee

can´t you share the first header line?