I have a scenario to create an excel file with 3 sheets.
I have used the export data store entity to excel smart service in the model back-to-back (3 times). I gave the folder to the first node, configure the output document of first node and provided the document to update field in second and third nodes respectively in order to update the same sheet.
The process executes and returns the excel document that i expected. But in the history, after the execution of first node, i have one document id generated and after the execution of last excel node, another new document id is generated.
At the end of the process, i write the documentId in a table. In the mentioned folder i can see only one document which is the first one.
Please let me know what should i need to do? Thanks In Advance,Vishnuvarthan.
Discussion posts and replies are publicly visible
Are the 2nd and 3rd nodes's 'Document to Update' attribute set to the pv containing the output from first DSE to excel node?
Idenally multiple nodes like this create new versions of the same document, I am guessing somewhere between 2nd and 3rd node the 'Document to Update' and Output document have some variable mapping issue.
Also worth checking is the target folder mentioned in 3rd node is accurate.
Yes, the 2nd and 3rd nodes's 'Document to Update' attribute set to the pv containing the output from first DSE to excel node.In the documentation it is mentioned to have the target folder only for the first DSE excel node and the following nodes it will be empty.
I hope you followed this documentation and used the correct sheet numbers for the updates.https://docs.appian.com/suite/help/25.2/Export_Multiple_DSEs_to_Excel.html
vishnuvarthans said: i can see only one document which is the first one.
Since you are adding sheets to the Excel file in this case, you can see multiple versions of the document, but there is only one actual document. Could you please verify how many versions were created?
Okay and is the same pv used in output node of 2nd DSE as well?