Challenge #479: Raw Material Lot Allocation

[patrick_digan]

I used the Alteryx Abacus for fun. The ability to store hidden variables is powerful.

Spoiler

[RolandSchubert]

Spoiler

[AkimasaKajitani]

My solution!

I'm also confused by the output.

Spoiler

[Erin]

Like others, I don't really understand the question. I think I'm missing a piece of the puzzle. For example, in Finished Goods Requirements, are we going for QTY or SUB QTY? Well, either way my solution doesn't match the posted so I'm utterly lost. 😅 

Gave it a shot and looking forward to when the solution is posted! 

[JBevan89]

Same as everyone else, that the solution output is different.  Hopefully either the output get's revised or when the solution gets released we can all realise what was needed to be done to get the solution output.

[olga_strubbe]

Thank you @cwkoops

This was a tough one.  I had a bit of a hard time in following it and leveraged the solution shared by @DaisukeTsuchiya  - thank you for sharing your logic on this!  The results did not quite match on the last record for the lot number - looks like quite a lot of folks were struggling with this one as well and not able to match the results fully.  

Spoiler

Iterative macro:

[SteveY02]

No idea. Is anyone know how to solve this quiz?

[ahsanaali]

Spoiler

 The Macro

[alexnajm]

@AYXAcademy the solution file provided produces 2 records whereas the expected solution indicates 10 records. Can we get any clarification on this discrepancy and any of the issues noted by the Community members? Thank you in advance!

[tammybrown_tds]

I couldn't make my macro work...and actually had difficulty understanding what the challenge was asking us to do.  So I downloaded the "official solution" and that solution doesn't match the output in the challenge either.

So I gave up.

My attached workflow is in all its errant glory.  Don't download it if you're looking for help solving the challenge.