Replace Tool Default to ENTIRE FIELD

Question

Hi All,

When dragging a Replace Tool in the workflow, the Find settings defaults to "Any Part of Field". This is dangerous if you're expecting an exact match. Because most of the time, we're always expecting an exact match, like what we're used to VLOOKUP in excel. Is there a setting in Alteryx that changes the default to "Entire Field"?

flying008 · Accepted Answer

Hi, @ricoo

You can suggest to the software vendor to change the default option to exact match here, but so far, the software option itself does not provide this additional switch.

andrewdnolan · Accepted Answer

I agree with the first reply, although it would be a nice feature in Alteryx to denote preferences or establish default selections, each tool requires some type of input, so I would guess that it's not an option yet.