Convert Different String Names into a Unique Standard Name

Hi people I have the dataset attached. This is the result of a join using my own input files and other Dataset beyond my control and located in a server with restricted access. I want the column Employee Name to have a unique string model for the name and avoid situations like the ones below:

QUIRRION,DENISE J

QUIRRION, DENISE J

Expected String Model: QUIRRION,DENISE J

DAY, PEG A

DAY, PEG

Expected String Model: DAY, PEG

BUREAU, DIANE D

BUREAU, DIANE

Expected String Model: BUREAU, DIANE

APPLEBEE, CAROL A

APPLEBEE, CAROL

Expected String Model: APPLEBEE, CAROL

This happened this time with this Employee Names, but I'm afraid that this could happen again with other names. What would be a method/approach I can adopt to develop a solid workflow that can provide consistent results for the Employee Name column.

Thank you in advance for your comments, your support would be really appreciated.

RHxlsx.xlsx

Workflow

Datasets

Output

Tips and Tricks

Custom Tools

Parse

Join

Accepted answers

alexnajm

Understood - try this out then! Workflow attached:

Convert Different String Names into a Unique Standard Name.yxzp

All comments

alexnajm

What is the consistent logic you'd want? To remove all middle name initials from the end? In that case, what is the logic for keeping Denise's initial?

araquecastro

Hi @alexnajm . Thanks for the reply and observation. The names has to be preserved this way LAST NAME, FIRST NAME, without any additional letters, spaces, symbols, etc.

alexnajm

Understood - try this out then! Workflow attached:

Convert Different String Names into a Unique Standard Name.yxzp

araquecastro

Thanks @alexnajm . The only problem is that I'm not able to open it due to my Alteryx version, I have the 2021.2.1. The company I work for has a pending upgrade to the version 2023.1 for January 20/2024. What do you suggest me to do to open the shared workflow?.

Thanks for your reply.

alexnajm

You can still open it - it typically just asks “do you want to try” and it’ll work.

if not, you can right click on the saved file and edit the version in a text editor like Notepad!

araquecastro

Thank you @alexnajm I went to the folder and opened the .yxmd attached version. It worked great. I will mark it as solved.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703