Output separate files into separate templates

xariet

Hi

The task is to output files into templates. I know how to output one file at a time into the template. Is there a way to do it for multiple files at the same time? 

There are 30 files  (raw data) for 30 different customers and one template. The output should be 30 filled templates.

Will appreciate any suggestions

template.xlsx

raw data.xlsx

output.xlsx

MatthewO

@xariet I recommend looking into the Reporting tools which allow you to format data before it is written to Excel. The attached workflow demonstrates how you could approach this. The Render tool allows you to Group Data Into Separate Reports so that each customer could be written to their own file.

Template.yxzp