Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA solution to last week's challenge can be found here.
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.
Random start to the week!
I am still unsure whether I understood the prompt correctly
And the macro inside, just to remove the columns that are going to be replaced