Hi Team,
I want to export more than 50 columns. Created a process to generate two excel and merge them
Case 1: If using to new doc in both smart services.
The combined doc is not started from specified cell. It starts from last data of first doc. E.g If first excel data ends at AV81 and other sheet starts from AW82, actually it should start from AW1.
Case 2: If I am updating the first doc then the data of 1st doc is not reflecting and only 2nd excel document data is reflected
Please let me know how to fix this.
Thanks
Discussion posts and replies are publicly visible
Can you try using the "Document to Update" and "Starting Cell" parameter in the second export DSE smart service to update the first document from the desired cell position instead of creating 2 documents and merging them
Starting cell for First Export = A1
Starting cell for Second Export = AW1
I have tried that as well as mentioned in case2
In the screenshot attached the data of first excel is cleared and only data from second excel is showing on updating the exisiting document.
vikashk7323 have you found any workaround for this issue to export more than 50 columns in a single excel sheet?Soma
Actually you can try by storing the data in database of the 2 excel sheets from there you can use Dse to excel smart service and more than 50 columns we cant export in Appian right now.
May be you can try to divide the columns in different sheets in single excel
Hi Vikas,
Generally Export DSE to Excel will not allow you to export more than 50 column, if customer allows then offer them to split the data in multiple sheets, Else try using export Cdt to Excel ( depricated but still in use) or Export sql to excel which will help you to export required data.