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

Asteroid

Solution attached, an iterative macro.

Spoiler
09-10-2019 08-41-41.png09-10-2019 08-41-59.png

 

Alteryx Partner

Can finally attach files, although cannot edit my previous reply

Alteryx Partner

My solution

 

Spoiler
challenge_108_RODO_Solution.png
Alteryx Partner

HeLa Cool!

 

My solution wasn't though.  Quite clunky but I got there

 

Spoiler
Process
- Change data type of HeLa Cell Count to Int32
- Generate a bunch of rows (I chose 50 for some flexibility - though I knew I only needed 14 splits)
- Calculate Max Cells (30 * 400,000)
- Calculate date/time for each cell split
- Calculate number of cells after each split
- Calculate start date/time for each cell split
- Set flag for when number of cells exceeds the max cell count
- Filter out those iterations where cell count is less than max cell count
- Choose first instance where cell count exceeds max cell count

If I shifted some of these tools around I could reduce a couple of steps and/or number of tools....


MySolution.PNG