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.