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) |
Solved! Go to Solution.
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!
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)
Actually I see you dont want to split them out separately. I'll post the updated one in just a second.
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) |