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 CompanyEntityKey Word CompanyEntityDescriptionABC LtdMini MartInnovation ABC LtdMini MartMini mart promote Innovation I tried Join tool and Find&Replace tool as well but couldn't acheive this.

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

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.

Fuzzy Match

Join

Accepted answers

Qiu

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

1109-lstalin.yxmd

All comments

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

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

1109-lstalin.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167