We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #268: Definitely Not Made Up

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here268_image.png

 

This week's challenge was submitted by @Qiu - Thanks for your submission!

 

Many datasets contain sensitive information that cannot or should not be shared freely. But there are also occasions where you need to share those datasets to get help or test the schema in a new process.

 

This week's challenge centers on replacing sensitive values with synthetic values from a list in a random fashion. The wrinkle is that the lists can have different numbers of values for their respective columns between runs. Create a solution dynamic enough to accept either list of synthetic values without any configuration changes.

Aaron_Harter
11 - Bolide

Random start to the week!

Spoiler
1.PNG
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1621258500551.png

 

dsmdavid
11 - Bolide

I am still unsure whether I understood the prompt correctly

 

Spoiler
dsmdavid_0-1621261084934.pngshould be able to accept a random number of columns.
I'm a bit confused about the same entity getting different "anonymised" entitites 😅

And the macro inside, just to remove the columns that are going to be replaced

dsmdavid_0-1621261291222.png

 

 

 

PhilipMannering
14 - Magnetar
14 - Magnetar
Spoiler
Definitely not the best solution...
Challenge 268 - Snip.png
patrick_digan
16 - Nebula
16 - Nebula
Spoiler
I went for dynamic replace.
patrick_digan_0-1621261328036.png

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
268.jpg

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1621263583878.png

 

Cheers!

Phil

AkimasaKajitani
15 - Aurora

My solution. 

This workflow is 100% dynamic solution.

 

Spoiler
AkimasaKajitani_1-1621267374231.png
Macro :
AkimasaKajitani_2-1621267420650.png
alexvornsand
7 - Meteor
Spoiler
Workflow.PNG