Hi Below is my question how to convert Inputs into correct output using Alteryx, can somebody provide me the solution. InputOutput NeededAnamikaVishnoi (11111111)Vishnoi,Anamika(11111111)Awasthi,Aman (2222222)Awasthi,Aman (2222222)BishalBhandari (33333333)Bhandari,Bishal (3333333)ChandanUpadhayay (44444440)Upadhayay,Chandan (4444444)DeepakNegi (555555555)Negi,Deepak (5555555)Dhami,Harish (9999999)Dhami,Harish (9999999)DharmeshKumar (99889898)Kumar,Dharmesh (9988989)

Column Correction for Name and Employee ID

Hi Below is my question how to convert Inputs into correct output using Alteryx, can somebody provide me the solution.

Input	Output Needed
AnamikaVishnoi (11111111)	Vishnoi,Anamika(11111111)
Awasthi,Aman (2222222)	Awasthi,Aman (2222222)
BishalBhandari (33333333)	Bhandari,Bishal (3333333)
ChandanUpadhayay (44444440)	Upadhayay,Chandan (4444444)
DeepakNegi (555555555)	Negi,Deepak (5555555)
Dhami,Harish (9999999)	Dhami,Harish (9999999)
DharmeshKumar (99889898)	Kumar,Dharmesh (9988989)

Accepted answers

FinnCharlton

@Puneet13 , try this:

Swapping Names.yxmd

All comments

FinnCharlton

Hi @Puneet13 , here's how I would approach this:

The RegEx can be updated to account for different types of names, ie those with punctuation. Hope this helps!

Swapping Names.yxmd

MilindG

@Puneet13 One way to do this

Puneet13

Thanks the quick response below is the also one more item available in the output could you please provide solution along with that it would be great help.

Input - AmreshKumarSingh (001175372)
Output - Singh,AmreshKumar (001175372)

cjaneczko

Try this. Adjust the column names as needed. Not sure which names are first names, vs last names.

Parse.yxmd

cjaneczko

Actually I see you dont want to split them out separately. I'll post the updated one in just a second.

cjaneczko

Try this one.

Parse.yxmd

Puneet13

Wont work for me it not showing as asked, sorry for the asking questions

Input	Output Needed
AnamikaVishnoi (11111111)	Vishnoi,Anamika(11111111)
Awasthi,Aman (2222222)	Awasthi,Aman (2222222)
BishalBhandari (33333333)	Bhandari,Bishal (3333333)
ChandanUpadhayay (44444440)	Upadhayay,Chandan (4444444)
DeepakNegi (555555555)	Negi,Deepak (5555555)
Dhami,Harish (9999999)	Dhami,Harish (9999999)
DharmeshKumar (99889898)	Kumar,Dharmesh (9988989)
MohdMujahidKhanSaddam (001448954)	Saddam,MohdMujahidKhan (001448954)

FinnCharlton

@Puneet13 , try this:

Swapping Names.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703