Challenge #72: Compare Data Sets (Fields/Columns)

The solution to last week's challenge is HERE!

Challenge 72.jpg

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”)!

challenge_72_start_file.yxmd

challenge_72_solution.yxmd

Developer

Reporting

Join

Preparation

Advanced

Intermediate

Data Preparation

Accepted answers

All comments

danbostrom

challenge_72_solved.yxmd

Dibas98

Solution

challenge_72_start_file.yxmd

mshishido

challenge_72_start_file.yxmd

cmoussa

challenge_72 CTM.yxmd

rapetter

Done

challenge_72_mysolution.yxmd

AthollJ

Solution attached

challenge_72_start_file.yxmd

robert-headington

#72

challenge_72_RH_solution.yxmd

martinson

Very nice

challenge_72_start_file.yxmd

myastarling

here's my solution! This is a tool I rarely use so it was nice to get some practice using it.

challenge_72_myastarling.yxmd

ntakeda

I like this tool.

Spoiler

challenge_72_ntakeda.yxmd

Tofel

Spoiler

challenge_72_Dom.yxmd

JBevan89

My Solution attached. A great challenge to show how to use the field info tool to compare. If you are comparing data from different sources, then there are obviously a lot of other ways, but with this exercise it was to show the purpose of the field info tool