If the file name is the same and the Excel writer has "Overwrite Existing File" set to No then data should be appended to the one file for multiple runs of the workspace.

Hi @gazza,

I am getting one Excel file per data source (CAD file) and it doesn't seem to matter if the overwrite is selected. The names of the Excel files created are taken from each CAD file processed. It does not give me a filename like I have specified in this dialog box. To be clear, this happens when I use Batch Deploy, not a single workspace run.

I haven't used Batch Deploy before but apparently there is an "Retain Source dataset basename in destination path" option when running it. What do you have that set to?

I have tried a few things, including unchecking that feature, but no luck. Will experiment a little more with it, and hopefully I can find more documentation somewhere. Stay tuned!

Still can't figure this one out. Tried all different combinations of the Batch Deploy parameters and set Excel Writer to no overright but only get either one source translation or both in separate files.

Select all data sources /files at once in your reader(s) and then make sure to use the same attributes in the writer. I recommend putting a sorter before the writer.