Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I prevent empty columns from being loaded from excel?

How do I prevent empty columns from being loaded from excel?  I know I can click on the "x" icon but there are hundreds of empty columns being loaded in.

2 Replies
vishsaggi
Champion III
Champion III

‌wwhy don’t you delete them from excel itself just select the columns with no data at all.

marcus_sommer

This is caused from any content which is in the columns. I'm not sure how Qlik identifies them but I assume that it just accessed the Excel meta-data information of UsedRange or something similar and this means that each cell which has different object-properties (in content and each kind of layout) then a default cell will be included.

The easiest way is suggested from vishsaggi just to delete this content respectively columns within the Excel itself. But even in Qlik it's quite easy done - not within the wizard else by clicking on finish and then removing all these columns in the script - just mark them by dragging the mouse and delete.

- Marcus