Create multiple files when updating a template from a blob

[Carlyn]

Hi - I have used a blob tool to pull forward a template from one month to create the next months.

I am then pulling in the new months data and use an append tool to create the new Full Path to output the file. This is all working fine and the new months data appears in the original template. However, can someone help me with how I can create multiple files using the same template? My output is already being used to 'Change entire file path' and selecting the Full Path so I am not sure how to add this extra step in.

[Dhrish]

@Carlyn Just make a Field with all the fullpaths and give that as field to Blob output tool.

[Carlyn]

Hi Drish - Thanks for responding. I am not sure I understand, I won't know all the fullpaths until I run the new months report. Do I need to change the order of my workflow to pull in the report with the data first?

[Dhrish]

@Carlyn Then you can use a bath macro to change the fullpath of Blob tool dynamically. As and when you create the filename send it out to the macro to create the files. This can be the filename for your template ie previous month and filename for your file ie current month.

[OllieClarke]

Hi @Carlyn 

As @Dhrish said you can create a fullpath using your data and pass that to your blob output tool. 

You'll need to reorder your workflow a bit, so you can create your fullpath based on the data, then output your template using that fullpath.



(your fullpath will look like: <Directory>/<Filename>.xlsx )

If you might be making multiple files with the same template, you can append your fullpath field onto your blobbed template, and the blob output tool will make 1 file for each unique value of your fullpath field.

Once the blob output tool has finished, you can then use the same fullpath field as the base for your normal output tool (although you'll need to add the sheetname and range to it like:

[Fullpath]+'|||<SheetName><Range> )

Hope that helps,

Ollie