Partial Match

[Kureel]

I am trying to combine two excels in Alteryx when the Sector names aren't an exact match. Some of the sector names will be an exact match but some aren't. I provided an example of the output I want but am open to suggestions about how else to present it. Essentially I need to know all locations that apply to a sector but with the sectors potentially having slightly different names.

[OllieClarke]

@Kureel If your data is the same as the mock data you provided, you could remove the location from the Sector, and use that to join the data sets. So 

TRIM(REPLACE([Sector],[Location],''))

This function will remove the location from the sector name (if it's there), and then remove any trailing/leading whitespace.

This would then let you join the two sets together.

Hope that helps,

Ollie