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
Here's my solution:
Spoiler
I just duplicated each value by its number (so 4 has 4 rows, 10 has 10 rows, etc.) and then used a MultiRowFormula to multiply the RowCount by the previous row's value.
The filter and select are just to clean up the output.
I just duplicated each value by its number (so 4 has 4 rows, 10 has 10 rows, etc.) and then used a MultiRowFormula to multiply the RowCount by the previous row's value.
The filter and select are just to clean up the output.
Although this challenge was pretty simple, I think it does a great job at showcasing some of the computational abilities of Alteryx. Great intro to macros for beginners
