Using Alteryx for text document analysis

Hello,

I would like to know if Alteryx can find a sentence with a keyword in it from a .txt file and somehow return that sentence to me? I know this might be a long shot but it would be SO HELPFUL when analyzing regulatory documents.

The key words I would like to use are: shall, may, may not, should, should not, must, can, cannot

Thank you in advance!

Reporting

Documentation

Accepted answers

CarlDi

Maybe this screenshot will help, I also attached the workflow in a yxmd file format. Be mindful of the Input data tool configuration - make sure the delimiter is \n and ensure field length is sufficient or it will truncate your sentences.

Hope that helps!

Keywords.yxmd

All comments

CarlDi

hi @krobot0915

Was thinking that if the sentences have periods (.), use that as a delimiter to split by rows with the text-to-column tool, so that each sentence would be have its own row. Then with the filter tool, use the contains expression to find the keywords. If you post the dataset, I'd be happy to take a look.

krobot0915

Hi CarlDi,

Thank you so much. Here is the dataset that has been converted from a pdf to a .txt file. Please let me know if you have any trouble with the dataset.

working-together-for-patients-grants-and-donations.txt

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335