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. Data.xlsx New Workflow2.yxzp

Finding Partial Matches Between Two Columns in Alteryx

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.

Data.xlsx

New Workflow2.yxzp

Workflow

Accepted answers

Raj

@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.

New Workflow2.yxzp

All comments

Raj

@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.

New Workflow2.yxzp

Buddhi_DB

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

Search tools High level result.yxzp

Raj

@Buddhi_DB
looks good to me

Raj

@Buddhi_DB
is this solved?

Buddhi_DB

@Raj Yes Thanks

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177