We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The solution to last week's challenge is HERE!
This week’s challenge is inspired by @SeanAdams’ mastery of the Field Info Tool! Can you follow in his footsteps to master the tool and use it in building a workflow that can compare two incoming data sets to see if they contain the same columns? Be sure to be sensitive to string case and any columns that have underscores substituted for spaces (i.e. “Store name” should match to “store_name”)!
Thank you @MattD, Solution is a bit different from others, I built a macro a few weeks ago to compare column headers (with a bunch of options for case, column ordering, type etc), and then compare the rows in each column too. It produces 3 outputs, one of which is a report format output. I know that reusing work that was done a few weeks ago is probably a cheat, so I'll apologise up front.
3 more to go to the big 75 - and it looks like @LordNeilLord is going to be very close to 75 in the next 2-3 weeks, so it may be a 4 way sprint to the final badge!
Fairly straightforward, and a great illustration of the tool.