Partial Match based on first 3char

[Nandy]

I need assistance matching two inputs, as shown in the example attached. I may have strings where the first three characters are constant and the last two characters vary. In these cases, when matching string pairs, if either one of them is present along with the remaining matched pairs, it is considered a match.

[Nandy]

The second output in example is as expected. 

[binuacs]

@Nandy one way of doing this

[Nandy]

Not exactly i need to join two concatenated fields with a partial match. I have modified your workflow attached. Apart from the data in Join, I will need the 3 ID present on the right side of Join as well as it has partial match ABC12, DEF12, and GHX00 to the left 

[CoG]

I don't entirely understand the specific requirements that you have, but you can just Join on the first three characters to get the "partial" match

[binuacs]

@Nandy