Naming the similar rows with a consistent name
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
 
- Labels:
- Tips and Tricks
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think the best way is to use the Find and Replace tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Kamran1991 ,
You may do it with find replace in an easy way.
Attached is a workflow with the approach.
Gabriel