Filter Records that contain Keywords from Multiple Columns

[jatienza]

Hi,

Need help in creating a workflow to filter records that contain keywords(see below) from multiple columns/fields in Table A. Please see sample data below:

Table A

Company	Address	State	website
Actual Inc.	Sunflower St. Don’t Subdivision	AR	www.actual.com
Metaphase Wrong	Active Bldg, Hero Village	IO	www.metaphase.com
Shoe Inc.	Blk 2 Lot 4, Leonardo Village	ST	www.shoe.com
Sunrise Company	Right Block, Medrise Subdivision	MARK	www.sunrise.com

Keywords

don't

wrong

hero

right

mark

axis

raise

verse

last

first

middle

upward

long

change

money

trait

lake

trust

[jatienza]

Outcome should be same as below since the record Shoe Inc. does not contain any keywords listed from the Keywords above.

Company	Address	State	website
Actual Inc.	Sunflower St. Don’t Subdivision	AR	www.actual.com
Metaphase Wrong	Active Bldg, Hero Village	IO	www.metaphase.com
Sunrise Company	Right Block, Medrise Subdivision	MARK	www.sunrise.com

[ShankerV · Accepted solution]

Hi @jatienza 

Please find the final one as per your expected output.

Many thanks

Shanker V

[jatienza]

hi @ShankerV , it's working, thanks.