Data Sorting and cleansing

[bnari12]

Hi Friends,

I have 3 columns in which the following are the details,

PO Number (Column A) : Has the PO details

Comments (Column B) : Comments associated with the PO

GR to be accrued ( Yes/No) Column C : Whether we can accrue the PO values i.e. Yes/No

My requirement is when we have comments like Correction - OPEX /Capex, Rebook, Correction, Manual, Deferral in comments column i.e. Column B it should show as No in Column C.

Can anyone help me with the Alteryx workflow for this.

Attached is the sample file, please let me know if you need any further details.

[pedrodrfaria]

Hi @bnari12 

See below for the WF using the Find and Replace logic to identify the matches and then the formula do update the field.