Export Data Store Entity to Excel

Question

Hi Everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8]
Scenario:
I have a scenario where 150 columns to be exported as excel.
Limitations:Using Export Data Store Entity to Excel, it supports only 50 columns.
Solutions tried:
Tried using multiple Export Data Store Entity to Excel with different Starting Cell (A2,AY2,BY2).
Issue:
The excel sheet is updating only with the last Export Data Store Entity to Excel Data. Previous Node data are getting erased.
What is needed?
I need all the 150 columns to be updated in the same Excel Sheet(Single sheet).

shubhama926776 · Accepted Answer

You used different Starting Cells correctly (A2, AY2, BY2) but didn't chain the documents. Each node was overwriting because it wasn't building on the previous output. Simply pass each node's output document as "Document to Update" to the next node - Node 1 output -> Node 2's Document to Update, Node 2 output -> Node 3's Document to Update.
This document chaining will append columns instead of overwriting, successfully exporting all 150 columns to one sheet.

If this will not work i already answer this question with different approach.

https://community.appian.com/discussions/f/data/34813/how-to-export-data-to-excel-in-a-grid-with-more-than-50-columns/134397

harshas2775 · Answer

You need to pass output of first DSE to excel node as &lsquo;Document to Update&rsquo; attribute of 2nd node. Similarly 2nd node output should be used as base for 3rd node and so on. Then all the nodes append on the output of previous node. So check this configuration and give it a try

Sign up

Login with SSO

Login to the community

Login with SSO