Need help in formula

[vishwa1979]

Dear Team,

I have two column data . PID and Reason.

I want only those PID if %wrong data entry% is there in the reason column

[OTrieger]

@vishwa1979 

Have you try to use a Filter tool with your criteria?

[ChrisTX]

Check out the Contains function: Functions (alteryx.com)

If you're just starting with Alteryx, review every Function so you'll know what's available.

Also recommend Learn > Academy > Learning Paths and Interactive Lessons.

Chris

[TUSHAR050392]

@vishwa1979 Another approach is using the match option in Regex tool followed by filter tool. See documentation on Regex tool- https://help.alteryx.com/current/en/designer/tools/parse/regex-tool.html#idp338234

[Yogesh1795]

use filter tool on Reason field, and select contains "wrong data entry " and you will get the desired result in true anchor