Important notice: All Credly Certification exam badges that have been unclaimed for 30 or more days will expire on August 28, 2024. To keep your badges active, log in to your Credly account and claim your badge before the deadline. (Don’t worry, this does not affect your Community badges!)
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
Révélation
Batch Macro Use Case
Use the Control Parameter to Update the file path - union data auto configure by name.
Use the Control Parameter to Update the file path - union data auto configure by name.
retaking this to prep for expert exam
proposed solution
bonus question
Révélation
another Control Parameter tool combined with an Input Data tool as to influence the file type for data input, meaning the Dynamic Input tool would not be used then
A neat challenge, thank you, @EddieW - true to real-life use case.
My workflow:
My macro: please update macro input with your file path - I entered a placeholder in the attachment - sorry, not able to share mine due to security. Thanks!
My solution attached.
Unfortunately could not get file 3 to load, because it says that the schema changed. Could not figure out why because all of the columns are the same. In order for the solution to work all the file schemas need to be the same.
