[ad_1]
I have a SQL/Snowflake dataset that has similar string values and I’m trying to group them together. For example, the table below is a sample dataset and there is a column called CONTENT with the following string values:
As you see below, they all have the words Farmer Land in common. There are several other strings with similar patterns as well.
CONTENT | ACTIVITY TYPE | LEAD_ID |
---|---|---|
GC EB Farmer Land eBook ww_farmer_EN | Fill Out Form | 342413 |
GC FB Farmer Land AMER eBook_JP | Fill Out Form | 175646 |
Farmer Land ww.pdf | Social | 5354676 |
2021Q1 Costs ebook Farmer Land ww EXP | Social | 54232344 |
EDIT:
I have another table called PROGRAM that has a string value called “EB-Farmer Land” and the string value in the table above should be replaced/grouped by whatever closest string value it can find in the PROGRAM table.
[ad_2]