Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Randomize Names

Highlighted
11 - Bolide

Hello,

 

I would like to randomize names. 

Sample input:

Sample input.png

Sample output:

FirstMiddleLast
AlexCHonda
Justin Melvin
KerryDLewis
ScottWPeeler
Chris Suzuki
JohnEToyota
Andy Winwood
PoleBDever
TonyASmith

 

Does anyone know how to randomize names?

 

Sincerely,

Kazumi

Highlighted
16 - Nebula
16 - Nebula

How about the following:

 

1. Transpose so data is row based

2. Add a Random column

3. Rank within the field (FIrst, Middle, Last) using a Multi-Row formula

4. Crosstab to make the random names.

 

This will generate the same size of data if you want a larger random set then I would do similar instead of ranking would just make random numbers equal to data set size.

 

Sample of the first method attached. If you need a sample of second happy to adjust

Highlighted
11 - Bolide

Thank you very much, @jdunkerley79!

 

Labels