Normalizer Exclude does not apply

Jihyun_Jeong · March 30, 2020, 2:38pm

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.

[Environment]
OS: Mac Catalina 10.15.2
Tested KNIME Version: 4.0.1, 4.1.2

[Steps]
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?

nemad · March 30, 2020, 2:44pm

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,
Adrian

Jihyun_Jeong · March 30, 2020, 2:49pm

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.