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):
Key words (Name column):
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.
Solved! Go to 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.
Thanks @Raj , In the meantime, I also prepared another flow, let me know your comments. This gives a high level result.
@Buddhi_DB
looks good to me
@Buddhi_DB
is this solved?
@Raj Yes Thanks