Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
wwhy don’t you delete them from excel itself just select the columns with no data at all.
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