Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #268: Definitely Not Made Up

RobertOdera
13 - Pulsar

My solution

Spoiler
RobertOdera_0-1683487264644.png

 

Carolyn
8 - Asteroid

Completed. I enjoyed looking at others' solutions

ed_hayter
12 - Quasar
Spoiler
Was a bit confused as to what we were trying to do here. But I went down the route of making a macro to randomly select one of the synthetic substitutes for the sensitive information. Then played with field mapping to use it again for when we were substituting in for the other field. I assume the logic here is you want to randomly impute for each individual field so that sensitive combinations cannot still be picked up even after randomizing.

ed_hayter_0-1685975607490.png

 

trepryor
8 - Asteroid

utilized the randint function after counting how many of each row existed

randomize workflow.png

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_268_KU.png
Dani_Lin
8 - Asteroid

sovled

tristank
11 - Bolide

This is another one of those challenges where I read the prompt, immediately said no and didn't tackle it until a few days later. That said it was very fun and I think I have introduced an appropriated amount of randomness.

 

Spoiler
268.png

 

caltang
17 - Castor
17 - Castor

Nice! RAND() all the way.

 

Spoiler
Screenshot 2023-06-30 124223.png

 

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
mithily
8 - Asteroid
Spoiler
rand()
olga_strubbe
10 - Fireball

Thak you, @Qiu!  I liked the use case of Unique Tile tool in the proposed solution - this was a very elegant approach. 

 

2023-08-23_09-44-13.png