Joing 2 Tables - With 3 variable conditions(Including one "Contains" condition)

[lstalin]

Hi All,

I am loking for a solution toconbine 2 table. I have to consider 3 fields in joining condition. The below fields from tables 1 & 2 should match as the Company name and Entity is same and the description contains the key word Innvation.

Table-1				Table-2
Company	Entity	Key Word		Company	Entity	Description
ABC Ltd	Mini Mart	Innovation		ABC Ltd	Mini Mart	Mini mart promote Innovation

I tried Join tool and Find&Replace tool as well but couldn't acheive this.

[Qiu]

@lstalin 
Maybe we can join the 2 tables with Company name and Entity fields first then use a filter tool with Contains Function to further filter the result?

If you can provide a larger dataset, we can prepare a quick sample maybe.

[lstalin]

Please find the below table. Trying to add category from table-1 to table-2

Table-1					Table-2
Company	Entity	Key Word	Category		Company	Entity	Description	Category
ABC Ltd	Mini Mart	Innovation	Laxuary		ABC Ltd	Mini Mart	Mini mart promote Innovation	Laxuary
ABC Ltd	Mini Mart	Timekeeper	Economical		ABC Ltd	Mini Mart	New Product Development	Economical
ABC Ltd	Mini Mart	New Product	Economical		ABC Ltd	Super Mart	Super Mario Game	Cheap
ABC Ltd	Mini Mart	Cheap Product	Cheap
ABC Ltd	Super Mart	Toyman	Cheap
ABC Ltd	Super Mart	Super Mario	Cheap
ABC Ltd	Super Mart	Super Man	Laxuary
ABC Ltd	Super Mart	Innovation	Economical
ABC Ltd	Super Mart	New Product	Laxuary

[Qiu · Accepted solution]

@lstalin 
Just quick sample and have not consider the exception processing given the data volume.