Add option to drop "unfound" values in Find replace tool configuration

[bkwilson]

Currently there seems to be no way to "drop" or remove lines if no match is found, even if you have asked to "Match Whole Word Only". I think it would be useful to have the option to completely remove entire rows if it contains what is essentially an invalid entry.

For example:

Rows 4, 5 and 6 do not conform to the correct format that I want to find and replace. They are invalid. With Find replace as is, the output would include the invalid rows. It would be much easier if FR had two outputs, one of which includes the invalid rows, if given the config option to drop any fields that did not match the reference table.

[KylieF]

Thank you for your idea and feedback!

And thank you for including visuals! It greatly helps our product team when reviewing an idea. After a quick review your idea looks like it has all the components needed to go to our product team once the necessary like count has been met. If you haven't yet please be sure to check out our Submission Guidelines.

[SeanAdams]

Hey @bkwilson , 

Not exactly what you're looking for, but the usual way to achieve this is in the Find and Replace tool, you use the "append fields to record" option - and then use a filter to check for missing lookups.

Or alternatively, you could use a Join tool instead of Find & Replace.

Both options should achieve what you're looking for as a workaround.