Iterative Macro | No in/output when using dynamic file

Question

Hi community members ,

I’ve been struggling for many days with my batch allocation problem. I’ve gotten to an iterative macro which works great when I use text input, however it doesn’t seem to create any output when I link it to a excel data source.

How do I make sure that the macro takes the left and right input anchors that a drawing data from a locally saved file?

Why is my macro not creating output, while it works perfectly fine using text inputs.

Your help is much appreciated!

Thanks,

bart

Batch Allocation Problem.zip

BartH · Answer

Thanks for your help and feedback.

I’ve swapped the text data input for a excel file and toggled the “show field map” option off in the configuration.

The macro runs smoothly now, also when I update my source data sheet with different sku’s/inventory/demand views it runs completely fine.

I’ve deconstructed much of the workflow and run into some other bugs which I’ve managed to resolve by ensuring that the text input matches the same data formats.

My learnings so far:

* Reason why my macro wasn’t looping in the new sample data, was because I used the wrong input data type.
* Text input will help the macro to recognizing the inputs, so that they can be assigned.
* Adding the text input back into the macro also ensure the String field error was resolved.

As a next step, I’m trying to loop in more items and customers with different shelf-life requirements so this will be a very interesting workflow!

CoG · Answer

Wow! You have included an incredible amount of information to work with. Thank you!!! And your workflows have comments :D  My only complaint is a small one, but the zip folder is a little cluttered making navigation harder than I think it needs to be (in general its better to save workflows with dependencies like macros/output files/input files as .yxzp by going to Options -> Export Workflow), but that's nothing compared to how wonderful all the information you included is.

I added comments in your Inventory Allocation Macro. I'll let you debug from here. Feel free to ask for further help if you have new questions, but this should get you going in the right direction at least.

Happy Solving!!!

NEW_Inventory_Allocation_Workflow.yxzp