We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

cc000072
8 - Asteroid

Here is my solution, it was good Weekly Challenge to understand way to use Field Info tool!

Spoiler
WeeklyChallenge_Ryohei_72.JPG

 

JonathanW
8 - Asteroid

Solved!

 

Spoiler
JonathanW_0-1593580853601.png

 

AnaisComyn
9 - Comet

Done !

RahulSharma
7 - Meteor

Solution

jarrod
12 - Quasar
12 - Quasar

nice.

Spoiler
jarrod_0-1594923595751.png

 

Dominik2806
8 - Asteroid

This was a nice one to try the fuzzy match tool...

Spoiler
Dominik2806_0-1595496974021.png

 

Verakso
10 - Fireball

Great tool.

Spoiler
Okay, so obviously there is a difference between the Join Tool and the Join Multiple Tool.

When using Join Tool, I struggled with the order of the output to match the provided result, but if I switched to the Join Multiple Tool, everything looked nice, easy and correct

2020-07-30 13_10_36-Window.png

 

Still Climbing
/Verakso

wwatson
12 - Quasar

my solution

JethroChen
10 - Fireball
Spoiler
challenge_72_jc.PNG
bjkay30
8 - Asteroid

I accomplished this one using a join and a union to get it all together, but interesting to know that you can accomplish the same thing with the multiple join tool.  I love learning new ways to accomplish the same thing!

 

Spoiler
bjkay30_0-1600195531322.png