Finding Partial Matches Between Two Columns in Alteryx

[Buddhi_DB]

Hi everyone,

I have an Excel workbook with two sheets: "Source Text" and "Key words." The "Source Text" sheet contains a column of narratives, and the "Key words" sheet contains a list of keywords. I need to find any part of each keyword that matches any part of each narrative.

Here's an example of the data structure:

Source Text (Narrative column):

• MONTHLY PLAN FEE
• DEPOSIT LOGANDIST2 LOGANDIST2
• DEPOSIT-OSKO PAYMENT 2512203 Masons Prestige W...
• DEPOSIT-OSKO PAYMENT 2385331 DAVID JEFFREYS W1...
• DEPOSIT-OSKO PAYMENT 2173035 SCS4WD 02 JUL 2023

Key words (Name column):

• DWYER PHILIP
• Philip DWYER
• MUDANNAYAKE NISHANT
• Nishantha MUDANNAYAK
• Kids Big Day Out Sou

Could anyone guide me on how to set up a workflow in Alteryx to achieve this? I need to generate a list of all narratives that contain any part of any keyword. Attached the workflow I built so far.

[Raj · Accepted solution]

@Buddhi_DB 
hi please find the flow attached
i do not find anything in it so added word "Deposit" for demo purpose
find an replace tool helps to achieve this job

mark done if solved.

[Buddhi_DB]

Thanks @Raj , In the meantime, I also prepared another flow, let me know your comments. This gives a high level result.

[Raj]

@Buddhi_DB 
looks good to me

[Raj]

@Buddhi_DB 
is this solved?

[Buddhi_DB]

@Raj  Yes  Thanks