Exclude columns in One hot Encode

Hello,

I was using the below one hot encode macro that is available on gallery on my categorical data.
https://gallery.alteryx.com/#!app/One-Hot-Encode-vPython/5caaef618a93370e4021a3ed

I want to omit encoding certain "string" type columns. I want these columns to appear at the output and so deselecting them in select tool is not an option.

Is condition tool a correct tool to use to exclude these columns?
If yes, where should I add this tool?

Gallery

Macros

Accepted answers

Aguisande

Hi @smarapad

How about splitting the treatment?

I mean, one stream for the "hot encoding" and the other untouched.

Then join them together.

That'll give you what you need.

All comments

Aguisande

Hi @smarapad

How about splitting the treatment?

I mean, one stream for the "hot encoding" and the other untouched.

Then join them together.

That'll give you what you need.

Deepvijay

Hello,

Thanks for sharing the solution. But I do not see the tool only (which you've used in snapshot). From the gallery, I'm getting the macro version. How can I get the tool?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703