Output data into excel template - header issue

zanjam

Hello

I'm having an issue with running my batch macro to populate an excel template per person because one of the headers is the individual's name therefore the schema changes between each iteration (causing the batch macro to fail). Any ideas on how I can keep the keep a dynamic header for an individuals name or how to output to an excel template without including the header?

Cheers

ddiesel

Hi again, @zanjam!

I think you only need two small modifications to get this working.

 

First, the Output Tool should be inside the macro so each iteration ends by overwriting a template, instead of trying to bring the data all together again in the workflow.

Workflow Before:

Workflow After:

Second, you need to control the portion of your macro that outputs the imported blob template, so that the template is created before the output file is written. You can accomplish this with the Parallel Block Until Done (Crew Macro).

Macro Before:

Macro After:

I replaced all the dependencies and ran on my machine with these two modifications. Everything seemed to match your SampleOutput with new files created: 12345.xls for John and 36272.xls for Bob.

Please give this a try, and let us know if it works for you!

Dummy_Workflow.yxzp