Is Included In

Ask for Help
1

How does “Is Included In” actually work when comparing?

In table 1 (Target Accounts) I have "GUITAR CENTER HOLDINGS " and I am comparing the row to table 2 (Partner Accounts) which matches 5 records: 2 entries "GUITAR CENTER HOLDINGS " and 3 entries “GUITAR CENTER”

I have lots of other records with “CENTER” and “HOLDINGS” and it doesn’t match those. But it does pick up “GUITAR CENTER”

Not sure what logic/magic drives the ‘is Included In’? Actually the results are what I want; I just don’t understand why.

image
image256×456 14.3 KB

2

The text strings “Guitar Center” AND “Guitar Center Holdings” are included in the text string “Guitar Center Holdings”.

How are you structuring the comparison? Which table is table 1 and which is table 2?

Based on your screenshot, I assume the screen value is the Guitar Center Holdings and each matching table value is included in that screen value.

Maybe you want to use Includes instead???

3

I am comparing "Guitar Center Holdings " in Target Accounts (with a space at the end) against the values in Partner Accounts.

In Partner Accounts there are three rows with “Guitar Center” and two with "Guitar Center Holdings ". So I have 2 exact matches and 3 ‘fuzzy’ matches (“Guitar Center”) But plenty others with “Center” and “Holdings” do not match which is the confusing part. Shouldn’t they match too?

I actually get the result I want (all Partner Accounts that include “Guitar Center”) but since I started the search with "Guitar Center Holdings ", I am surprised it worked how I wanted since I other accounts would have matched ‘Center’ and ‘Holdings’ but did not.

4

If the values are only “Center” and only “Holdings”, then yes I would expect them to match as well, but if they are something like “X Center” or “Y Holdings” then I would not expect a match because “X Center” and “Y Holdings” don’t exist in the string “Guitar Center Holdings”.

Included In = a left to right match.
(Values in rows being searched are Included somewhere In the search text)

Includes = a right to left match.
(Values in rows being searched Include the search text somewhere within themselves)

1 Like
5

I will test it out. Thanks Jeff.

6

Thanks again Jeff. Tested a few and you are correct. It is just a little weird to think Guitar Center Holdings is “Included In” Guitar Center but it works out.

Guitar Center Holdings is included in:

Guitar
Center
Holdings
Holding
Center Hold
Center Holdings
Guitar Cen
Ter Hold
Tar Cen
Cent

It is not included in
Guitar Holdings
TarCen
GuitarCenter

7

I think you are still picturing it backwards. “Guitar Center” is included in “Guitar Center Holdings”. Not the other way around. If you read it left to right like a sentence, then it makes sense. That’s why I mentioned maybe using Includes instead of Is Included In, which might make more sense for your use case. You want to find matches that Include your search term instead of finding matches that are Included In your search term. But maybe I’m misunderstanding the goal.

2 Likes
8

I never actually understood how it worked - my bad since it seemed somewhat counter-intuitive - but it works as I needed/hoped it would (matching names that are close but not exact).

Thanks for the color on its operations.

1 Like
9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.