Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

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
16 - Nebula
16 - Nebula
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
16 - Nebula
16 - Nebula
Spoiler
Definitely not the best solution...
Challenge 268 - Snip.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
I went for dynamic replace.
patrick_digan_0-1621261328036.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
268.jpg

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1621263583878.png

 

Cheers!

Phil

AkimasaKajitani
17 - Castor
17 - Castor

My solution. 

This workflow is 100% dynamic solution.

 

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