"Categorical field" into a “collection of flag fields”

[molnarm]

How to derive a categorical field to a collection of flag (true/false) fields in Alteryx?
E.g.: field_male_female => flag_male and flag_female
I understand: I can do it with R node with script but is there any simpler way?

[chris_fort · Accepted solution]

There are several ways to do this,

One option is to use the transpose tool, placing the "field_male_female" as the header field and counting the number of respondents. Following that, you can use a multi-field formula to replace null values with zeros.

Before:

Process:


Quick answer, so hope it makes sense!

Chris

[molnarm]

Do you mean Crosstab Tool, don't you?
It works fine, thanks a lot.

Addtional question:
What is Alteryx-recommandation for handling/managing categorical fields with a lot of categories (in string type field) for regression problems (with numeric or binary target variable)?
Conversion these string/categorical fields to numeric fields via Formula node?
Ot binning with any kind of parameterizing of Tile node?