In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Matching codes to text subject (Text mining maybe)

MZ900605
8 - Asteroid

hello guys, i need your help figuring this out, i have this raw data for subjects i need to match them to another Master file that has the name of the subjects.
 Screenshot (235).png

The master data contain the used term for the subject and its definition, so I should add a field in my Raw data that states the term of the subject which relates.

Screenshot (212).png

and a third file that has the code of this subject. Screenshot (234).png

The result should be a file that has the subject name from the raw data, and the related subject term from master data and finally the code that relates to the subject. Thank you very much for ur help guys so far.

Regards.

1 REPLY 1
Pravallika20
8 - Asteroid

Hi,

Can you please provide sample input and output files

Labels
Top Solution Authors