Exclude columns in One hot Encode

[smarapad]

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? 

[Aguisande · Accepted solution]

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?

[Aguisande]

Hi @Deepvijay 

What you showed in the screenshot is the macro itself. That macro is "packaged" as a tool.

What you need is an actual workflow (xxxx.yxmd) to use the macro (that looks like the one I used), and insert that macro (One Hot Encode vPython.yxmc)

from where you saved it in your disk (I strongly recommend to configure at least one default macro directory from the Macros tab in User Setting)

Hope this helps.