Data Cleansing

Question

I have various data cleansing tools in my alteryx flow, the fields get automatically unselected with few runs or changes in the flow, how to fix the selected fields in data cleansing tab so that they dont change with changed input or any other changes.

Aakanksha_chandak · Answer

Do we have any other way to do it?

FrederikE · Answer

Hey @Aakanksha_chandak,

The regular Cleansing Tool doesnt allow this, but you can modify it.

Go to C:\Program Files\Alteryx\bin\RuntimeData\Macros

Duplicate the "Cleanse" Macro and give it a new name.

Save and reopen Alteryx. Then go into the new (duplicated) Cleasing Macro and modify it.

In the 2 Select tools shown in the screenshot below you can select to include unkown fields as well. This would lead to your Macro always including new fields.