Export Data Store Entity to Excel

Question

Hi Everyone 
 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).

Shubham Aware · 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

Anusuya K Mahalingam · Answer

Hi Shubham, Will try this approach. I have the Excel Template with headers, in which these 150 columns data to be updated without modifying the Header Values in the Template.

Harsha Sharma · 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

Export Data Store Entity to Excel

Top Replies