Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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 #374: Using Iterative Macros

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_3-1686063815036.png

 




The simple way is to union the "Factorial" field using Unison tool.
AkimasaKajitani_0-1686063293329.png

 



Another way is using Detour tool or Container tool, but that way is needed to have nested macros.

AkimasaKajitani_1-1686063309550.pngAkimasaKajitani_2-1686063320374.png

 

 

Tofel
9 - Comet

Challenge 374 - Level up to Challenge 74 🙂

 

Spoiler
Tofel_0-1686072389498.png

 

Spoiler
Tofel_1-1686072426261.png

 

M__K__A
7 - Meteor

Similar to another post, I also needed to manually add the Factorial column to the Text Input tool and set the default value to 1.  Without this, I was having an issue where the value of the Factorial column would reset upon each iteration of the macro.

 

That said, I was able to arrive at a solution and I think it meets the criteria of the challenge!

alexnajm
18 - Pollux
18 - Pollux

This tells me how much I prefer standard and batch macros to iterative macros 😂

Spoiler
Challenge 374.PNG
PrinceAli64
6 - Meteoroid
Spoiler
Snag_1ef6f0e.png

Snag_1ef938d.png

alacoume
9 - Comet

Not sure i have answered the challenge because i have more than one multiplication by iteration! This is more a batch macro transformed in an iterative macro...

zacky546
8 - Asteroid
Spoiler
zacky546_0-1686132603900.pngzacky546_1-1686132631593.pngzacky546_2-1686132649552.png

 

FrederikE
13 - Pulsar
Spoiler
Time: 11:55
FrederikE_0-1686133542744.pngFrederikE_1-1686133545231.png

 

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
374.jpg
patrick_digan
17 - Castor
17 - Castor
Spoiler
The ensure fields macro helped out here.
patrick_digan_0-1686135975551.png

patrick_digan_1-1686135999844.png