Excel Reader response slowly when select columns

[cuimaple]

I want to select some specific columns from a Excel file, but when I use the “Transformation” tab to do that, I have to wait for long every time I click…Do someone know how to increase the speed to response?

[Nick_Reader]

Hmm, that is unfortunate. How big is your excel file? If it’s enormous, that could be a factor.

If the transform tab is giving you trouble, use a column filter node after the excel reader node instead.

[cuimaple]

Also there is not button to “unselect all”

[mlauber71]

@cuimaple what you could try to do is import the Excel via Python OpenPyxl.

Excel - Import very large File with Python and Apache Arrow – mlauber71

[prashant7526]

@cuimaple ,

I use easy and dynamic way to do that. I create one Excel that has all the columns to keep in one column as show in the Screenshot

I now get many different nodes to use to remove the unwanted columns. For Example:

1. Table Validator (Reference) – KNIME Community Hub
2. Reference Column Filter – KNIME Community Hub (In this case you can make you excel other way columns to be removed)
3. Joiner – KNIME Community Hub (I won’t recommend this)

I never touch that part of the Excel Reader.

[Nick_Reader]

Don’t think so, no. That’s too bad! Would be a great feature