Alteryx Designer Desktop Discussions

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

Naming the similar rows with a consistent name

Kamran1991
11 - Bolide

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.PNG

 

3 REPLIES 3
OllieClarke
15 - Aurora
15 - Aurora

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

OllieClarke_0-1632249613075.png

 

Hope that helps 🙂

 

MatthewBr
Alteryx Alumni (Retired)

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

 

 

Garabujo7
Alteryx
Alteryx

Hello @Kamran1991 ,

 

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

Attached is a workflow with the approach.

 

Garabujo7_0-1632250320034.png

 

 

Gabriel

Labels
Top Solution Authors