This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A 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.
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
This workflow is 100% dynamic solution.