Challenge #268: Definitely Not Made Up

[Qiu]

@olga_strubbe 
Thank you very much for the comment.
Tile tool can be very usefull for grouping. 😀

[gawa]

In my understanding, number of distinct count of original and replaced data should be matched... 

[anabelvelazque]

Hi! here is my take :-)

Spoiler

[alacoume]

A solution:

[networkmike42]

Spoiler

 

[Rob-Silk]

Solution attached below - should be dynamic for different lists of replacement values, as well as applying the same replacement value to the same original values so that the data set maintains consistency in analysis after anonymising client name and city

[snbandi]

My solution

[aiahwieder]

I think it could still be more dynamic . . . but I've hit my limit with detours.

[asultanov]

Spoiler

[Erin]

Big thanks to @grossal for explaining two formula options critical for this challenge! 
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Generating-Random-Value-betwee... 
I tried both ways and they work! I appreciate the comparison between these similar formulas:

Spoiler