Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #12: Creating an HR Hierarchy

michael_apau
8 - Asteroid

my solution

aaroncpotts
7 - Meteor

This was really rough for me. I'll need to do this again to understand why it works the way it does better. I need more macro practice and will be doing that through my company soon.

 

Spoiler
AlteryxChallenge12WorkflowAP.pngAlteryxChallenge12MacroAP.png

  

Johaon
6 - Meteoroid

This is too tough for me now...... Can anyone explain to me how this loops? How are the conditions for loop termination reflected?

Rhys_Cooper
9 - Comet

Excellent iterative macro question! solution attatched

Spoiler
Screenshot 2024-02-05 091221.png


Screenshot 2024-02-05 152737.png
nayeli_jaime
7 - Meteor

Screenshot 2024-02-09 140752.png

 Nice Challenge!

snbandi
8 - Asteroid

My solution after peeking through others and understanding there is more to iterative macros than merely a Filter condition as loop iterator. Great tool.

JWAJ
7 - Meteor

My first solution was pretty dumb why I don't hide it with a spoiler. I hard coded the solution by taking advantage of the fact that the employees was ordered in management hierarchy in the input file. By adding a Record id it is possible to find the difference of the employee record ID with any potential manager record ID:

  

 

2024-02-28_11-12-37.png

 I did not have experience with macros so i watched some youtube videos on how to use iterations in macros and came up with this:


Spoiler
2024-02-28_11-49-10.png

nli
8 - Asteroid

I found a solution without using a macro.

Spoiler
Challenge 12 Spoiler.png
Dev73
8 - Asteroid

got to learn the use of iterative macro

Spoiler
challange 12.jpg
asultanov
8 - Asteroid
Spoiler
Screenshot 2024-03-22 114646.pngScreenshot 2024-03-22 114656.png