Naming the similar rows with a consistent name

Question

Hi everyone,

I have dummy data, where rows are given as (this is just to exhibit the nature of data)

1. JAIPUR EE EXPENSE

2. JAIPUR EE EXPENSE FOR JULY

3. JAIPUR EE EXPENSE REV FOR JULY

4. JAIPUR EE EXPENSE CORR FOR JULY.

I want to name all these rows as JAIPUR EE EXPENSE because this is my head of the all accounts. There is no consistency in the format of items' name.

Once you go through the attached excel file, you can easily understand the query.

Can anyone help me to solve this problem?

You guidance will be highly appreciated.

Regards,

Kamran

Naming the similar rows with a consistent name.xlsx

Garabujo7 · Answer

Hello @Kamran1991 ,

You may do it with find replace in an easy way.

Attached is a workflow with the approach.

Gabriel

naming the similar rows.yxzp

MatthewBr · Answer

I think the best way is to use the Find and Replace tool.

OllieClarke · Answer

Hey @Kamran1991 here's an approach which might work after some tweaking:

I used Fuzzy Matching (in purge mode) after a tiny bit of pre-processing. Check out these links for more info on the tool if you've not used it: https://help.alteryx.com/20213/designer/fuzzy-match-tool ; https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

The regex in the formula tools looks for 3 uppercase letters immediately followed by 4 numbers to remove JUL 2020 style dates

Hope that helps 🙂

fuzzy Match.yxmd