Extract some words from a data set.

Ar13f

Dear All,

I hope all communities are in good health ...

Kindly need your help from you guys.

I have a role data like below and I want to only want to take some roles as written in the "Result" column.

Current Role Description	The Result
Proprietors,Beneficial Owners,Authorised Signatories,Approving Signatories	Beneficial Owners,Authorised Signatories,
Authorised Signatories
Directors,Shareholders,Authorised Signatories,Approving Signatories	Directors,Authorised Signatories
Directors,Beneficial Owners,Shareholders,Authorised Signatories,Approving Signatories	Directors,Beneficial Owners,Authorised Signatories,
Directors,Authorised Signatories,Approving Signatories	Directors,Authorised Signatories
Directors
Shareholders
Approving Signatories,Authorised Signatories,Directors,Shareholders	Authorised Signatories,Directors,
Approving Signatories,Authorised Signatories,Beneficial Owners,Director,Shareholder	Authorised Signatories,Beneficial Owners,Director,

Thanks a lot for the help.

Regards,

CarliE

@Ar13f 

Attached is a workflow

What I did was counted how many commas there was, if there were none, i left the field alone. If there were more than 0 I looked up if any of the roles that are bolded above are in the record. After that, I consolidated.

Please mark as a solution if this solved your problem

Thanks!

Extract some words from a data set.yxmd