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

hoadinh
6 - Meteoroid

My solution:

JasonHu
8 - Asteroid
Spoiler
workflow.pngmacro.png

Here is my submission.

cwkoops
8 - Asteroid

complete!

Elias_Nordlinder
11 - Bolide

My Solution.

 

Spoiler
Elias_Nordlinder_0-1626151749524.png

 

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

  • Try to make the workflow for first hierarchy level up
  • Looping in Alteryx works through Iterative Macro - which requires an iterative input which is output what you generate from the previous run, so ensure your output generation is getting updated i.e. it shouldn't be same as input and it should be going up the level
  • Engine iteration Number is a bliss!
Spoiler
Solution_12.PNGSolution_12_Macro.PNG
ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-17 233734.pngScreenshot 2021-07-17 233807.png

  

DanTh
Alteryx
Alteryx
Spoiler
First real look at Iterative Macros - take a look at the Interactive Lessons, which definitely helped me out! Had to use a lot of trial and error, even when looking at the solution. However, the initial Join logic I did get pretty quickly.

2/5
JoaoLeiteV
10 - Fireball

Tried escaping from using iterative macros, but the workflow would become way too big haha.

 

Spoiler
Workflow - 

JoaoLeiteV_0-1626897247695.png



Macro -

JoaoLeiteV_1-1626897256505.png

 

Tomasch
7 - Meteor

done

carmenrapariz
8 - Asteroid
Spoiler