Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
5 subscribers
Views
3267 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Export SQL to Excel Smart Service for multiple sheets
marcoc918
A Score Level 1
over 8 years ago
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
0
marcoc918
A Score Level 1
over 8 years ago
No i cannot find this document, but i cannot understand why.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
marcoc918
A Score Level 1
over 8 years ago
No i cannot find this document, but i cannot understand why.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data