Export SQL to Excel Smart Service for multiple sheets

Hi,

we need to extract data from our db from 2 different tables and inserting them in 2 different sheets of an excel template.

I have created the excel template with the 2 sheets, and I have created a simple process model with 2 Export SQL to Excel Smart Service:

1. The first one extract the data from the first table, fill the first sheets of the excel template, save the document on the Temporary Documents folder and within the Process Model on the pv!output_document

2.The second one should use this output_document as template, extract the data from the DB and fill the Excel. To do so I have set as:

Document_to_overwrite: pv!output_document

Excel_base_template: pv!output_document because it is necessary to use the generated excel of the first step as new template

but something goes wrong and the Alert is this:

There is a problem with task “Copy of Export SQL to Excel” in the process ...

OriginalPostID-257270

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data