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).
Discussion posts and replies are publicly visible
You need to pass output of first DSE to excel node as ‘Document to Update’ 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
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
Hi Harsha,
Tried this approach. But the excel sheet is updating only with the last Export Data Store Entity to Excel Data. Previous Node data are getting erased.
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.
Keep us posted.
Sure Shubham
Thanks Shubham :)
Using the Web API and Integration approach, able to get all the 150 columns in the Excel Sheet.Used GET Method in API and Integration.
Perfect!!Great to know that.