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.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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

nlensing001
7 - Meteor

Here is my solution.

JLdG
6 - Meteoroid

Nice solution! I didn't even think about using the randint() and count functions to create recordID's! Quick, easy and efficient!

LHolmes
9 - Comet

Liked this challenge as the refresher with certain formulas helps us solve a recent unrelated obstacle.

 

Spoiler
268 - Solution.PNG
ggruccio
13 - Pulsar
13 - Pulsar

Fun once you get the hang of it!

 

Spoiler
I used generate row to create the number of rows needed for the actual data then a random integer based on the count of records in the replacement file - then joined on the random integer to a record id.
DN
8 - Asteroid
Spoiler
Capture.PNG

stavros_
5 - Atom
Spoiler
stavros__0-1622784151484.png

 

kelly_gilbert
12 - Quasar

Since I work with HR data, this is something I have to do every once in a while! However, making this totally dynamic (if the columns in the original/replacement changed) was a fun challenge. Thanks, @Qiu!

 

 

Spoiler
My initial thought was to use Dynamic Replace, but the run time was MUCH longer vs. transposing and joining.


Outer workflow:

kelly_gilbert_1-1623553476162.png

 

Macro:

kelly_gilbert_0-1623553452055.png

 

Qiu
17 - Castor

@kelly_gilbert 

Thank you for the kind word. I am so happy to know it is useful for you. 😁

DawnDuong
12 - Quasar
12 - Quasar

I think the 2nd solution is not right as there are one-to-many relationships between the original vs. masked outputs.

rmassambane
9 - Comet

turututu turututututu