Challenge #268: Definitely Not Made Up

[nlensing001]

Here is my solution.

[JLdG]

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

[LHolmes]

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

Spoiler

[ggruccio]

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]

Spoiler

 

[stavros_]

Spoiler

[kelly_gilbert]

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:
Macro:

[Qiu]

@kelly_gilbert 

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

[DawnDuong]

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

[rmassambane]

turututu turututututu