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 |
Solved! Go to Solution.
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 |
hi @ShankerV , it's working, thanks.