Partial Matching the Columns

Question

Partial Matching the Columns

sathishkm

SSC Veteran

Points: 239
More actions
March 15, 2023 at 2:10 pm

#4161030

Hi All,
How could I partially match the columns from two different table. I have attached the excel sheet for reference.
Attachments:
You must be logged in to view attached files.

March 16, 2023 at 5:24 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32348 More actions · Answer 1

SELECT CompanyB.Value SourceValue, CompanyA.Value PartialMatch
FROM CompanyB
Left join CompanyA
on CompanyA.Value like '%'+CompanyB.Value+'%'

sathishkm SSC Veteran Points: 239 More actions · Answer 2

Its not executing it. I have attached the separate table.

I want to match from TableB

Attachments:

You must be logged in to view attached files.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

If you want really good help, then see the article at the first link in my signature line below for one of many ways to provide example data in a readily consumable format.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)