community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #108: HeLa Cell Multiplication

Nebula

Basic core Alteryx solution.  No Macros.  No highfalutin math.  Logs are for building homes with ;)

 

Slight difference with other core solutions having to do with the number of rows generated and how the start and end dates are calculated

 

Spoiler
Solution 108.png

Dan

 

P.S. Never had to actually spell "Highfalutin".  Seems like there aren't enough "o"s in it

Alteryx Certified Partner

 

My solution. I fell for the good ol' int-trap.

 

Spoiler
Macro:

Capture.PNG
Workflow:
Capture2.PNG

 

 

Pulsar

Fun challenge!

 

I think a great new tool would be a cross between the Generate Rows Tool and the Multi-Row formula Tool, where you can update the value of multiple fields with formulas each time it cycles through the loop and even refer to previous rows. I guess that's what Macros are for...

Bolide

Cheers!

Asteroid

Here is my solution

Alteryx Partner
Spoiler
WC_108_Solved_Macro.PNGWC_108_2.PNG

My solution.

Alteryx Certified Partner

My solution using Generate Rows

Fireball
Spoiler
I guess the easiest solution is to calculate the result mathematically, but I also took this as an opportunity to practice creating iterative macros!

Main workflow:
challenge_108_workflow.PNG

Iterative macro:
challenge_108_macro.PNG
Alteryx Certified Partner

I was afraid of the macro iterative - I came out without :-)

Alteryx Certified Partner

My solution - without macros