Help comparing two columns, Alphanumberic string vs longer string.

[wonka1234]

Hi,

Whats the best way to see if my data 2 is in data 1?

Data1
B2
C7
C33A
C19
B104
26

Data2
Paragraphs 14 to 24
Paragraph 16, 17, 18 & 47
Paragraphs 17.2 & 17.6
Paragraphs 17 & 47
Prargraph 9

How can I do this?

See attached workflow.

[Prometheus]

@wonka1234 You can use the Find Replace tool and configure it to match the whole word. You can choose to replace it by creating a column in your Data1 dataset or you can choose to append the found values into another column like I did.

 

[wonka1234]

@Prometheus  thank you, whats interesting, is we cant go the other way, it will be nulls.