Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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

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

Archie_bos
8 - Asteroid

here is my solution

Bren_Spill
12 - Quasar
12 - Quasar
Spoiler
Challenge #72 Workflow.PNG

 

olga_strubbe
11 - Bolide

Thank you, @MattD and  @SeanAdams for a fun challenge!  The  Field Info is quickly becoming one of my favorite tools - it is so powerful in comparing the fields across the workflows or finding columns with Null values - opportunities are endless.

My solution is in step with the proposed one using the Field Info tool and the Formula to standardize the column names to align the fields from the two data sources side by side. 

2024-01-31_11-00-04.png

Christina_H
14 - Magnetar

My solution

Spoiler
image.png
leonardstarrk
8 - Asteroid

New Tool learned!

Shaktikdhar
8 - Asteroid

Spoiler

 

Pic1.jpg

H_a_n_g_C_h_e_n__x3
8 - Asteroid

Fin

Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
2024-04-29_16-13-28.png

vmazur24052020
8 - Asteroid

Interesting tool. Thanks

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2024-06-06 195004.png