Macro Issues - "The Source Stream was not properly initialized"

Someone please help me with the attached workflow. I cannot figure out why the macro will not run. When I run the macro on its own it works for a single loop. But when I bring it to a workflow to run several loops it will not work and is giving me fits. Thanks!

whywontthiswork.yxzp

Batch Macro

Accepted answers

AbhilashR

I got rid of the Sample tool inside your macro and it worked. If you need it for some reason as part of your analysis, I would urge you to include the Sample tool in the main workflow that feeds into this macro.

All comments

AbhilashR

Hi @LoganJ, the issue wasn't in the macro, but the sources files feeding the macro. The excel source has null rows going into the macro which was causing the Append Fields tool (tool ID 11) to error out.

Include a Filter tool in your base workflow after the Input tool and get rid of the nulls rows. Something like the setup in the image below:

Hope this helps.

LoganJ

Thanks for your reply. This fixed the sample I gave you but I am still having issues with the full sized file.

whywontthisworkstill.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703