Normalizer Exclude does not apply

Hello KNIME Dev Team,

I’ve found that the function of Exclude in Normalizer doesn’t apply at all.

The following are the my environment and reproducible steps.

OS: Mac Catalina 10.15.2
Tested KNIME Version: 4.0.1, 4.1.2

Load a CSV file(For instance, Boston_house) -> Create Normalizer -> Link both > Configure Normalizer -> Exclude some columns -> Z-Score Normalization(Gaussian) -> OK -> Execute -> Normalized table -> There is no applied at all.


I’m studying Data Analysis with KNIME this semester under my master’s course.

The issue should be fixed as soon as possible to study properly for my study.

Could you please look into the issue above-mentioned?

Hello @Jihyun_Jeong,

I believe there might be a misunderstanding.
Judging from your screenshots the node does exactly what it was configured to do, namely normalize the columns in the include list using z-score normalization (i.e. ensuring a mean of 0 and a standard deviation of 1) while not normalizing the columns in the exclude list.
What behavior did you expect?

Kind regards,

1 Like

Hello Adrian,
Thank you for your quick answer.
As far as I understood, the excluded columns('OBMS., TOWN#) need to be not shown when the columns including Exclude sector.

Could you look into the issue again?

The following are what I expected after execution.

However, the OBS. , TOWN# displayed even I excluded as you can below.

As @nemad mentioned this is not a bug. For your purpose use Column Filter node to get rid of unnecessary columns.

1 Like

Hello @ izaychik63

Thank you for your quick answer

I got it. If so, like this, I can filter what I don’t need.



This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.