Hello!
I am trying to use Find Replace tool to extract a Category from a mapping file.
The original database contains free text input by the user - it can be different each time.
Based on keywords, I am creating a mapping and I have a difficult time when they are interfering and there is a priority in place.
This is a sample of the database.
| Text |
| Dental feb 23 |
| Dental accrual dec 12 |
| Accrual docs 3452 |
And this is a sample of the Mapping:
| Group | Text | Priority |
| Accrual / Reversal | accrual | 1 |
| Allocate/Record Dental | dental | 2 |
Basically, what I want to highlight is that if the free text contains "Dental" it will go under category Allocate/Record Dental, BUT if it also contains "Accrual" it will go under category Accrual / Reversal. That's why I thought to insert a Priority and sort them based on the Priority.
My logic says that when running the workflow, it should work. However, Alteryx is still mapping the text "Dental accrual dec 12" under Allocate/Record Dental instead of Accrual/Reversal.
Attached is the workflow that I tried.
This is what Alteryx is bringing me:
| Text | Group |
| Dental feb 23 | Allocate/Record Dental |
| Dental accrual dec 12 | Allocate/Record Dental |
| Accrual docs 3452 | Accrual / Reversal |
And this is what I want:
| Text | Group |
| Dental feb 23 | Allocate/Record Dental |
| Dental accrual dec 12 | Accrual / Reversal |
| Accrual docs 3452 | Accrual / Reversal |
Is there a solution here?
Thank you so much!
