Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sjbrickner
New Contributor

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.

Tags (1)
2 Replies
Highlighted
vishsaggi
Esteemed Contributor III

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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