• State Suggested Answer
  • Replies 7 replies
  • Answers 2 answers
  • Subscribers 22 subscribers
  • Views 895 views
  • Users 0 members are here
Related Discussions
Home » Discussions » New to Appian

Export more than 50 columns. Merge not working

vikashk7323
Certified Senior Developer

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

Parents
  • 0
    Certified Lead Developer

    I have recently got this scenario, and I have tried following available ways and I am putting detailed information here. Folks feel free to correct or let me know if we have some other way OOTB: -

    1. Generated two excel using Export Data Store Entity to Excel with 1-50 and 51-70 columns respectively. Then tried merging using smart service Merge Excel Documents
      • Output: The final document did not merge it, one after another (left to right) instead it merged top to bottom.
      • Please note,I have highlighted the header with blue color on excel just for visibility. It will not come from OOTB feature.
    2. Used Export Data Store Entity to Excel with 1-50 columns say DOC_1 and then used same smart service to update the DOC_1 for next remaining columns (51-70)
      • Output: It does update as expected but the header for columns 51-70 was not bold and was not expanded to its length like DOC_1

      • Inputs: When you use smart service DSE to excel second time to update DOC_1, you can pass all the parameters same as first time except below inputs: -
      • Just pass any random cell location where you are sure data from first smart service will never be loaded. It means we are telling the system you consider this point (A800) to load data from data base.

      • And then we can use inputs Custom Cell Positions and Custom Cell Values to update as per our need like below: -
      • You need to create a rule which will return the cell positions in left to right manner for each row like below
        • First AY,AZ,BA,BB,BC.......till last cell
        • Second row: AY1,AZ1,BA1,BB1,BC1.......till last cell
        • till last row
      • You need to create another rule which will return the cell values for the above positions in left to right manner for each row like above.
      • Then you can just pass on these parameters. MAKE sure Cell Position and Cell Value MUST be in same order.
      • I create a single rule of map type with key a!map(cellPosn: {}, cellVaues:{}) and dumped this in a PV right before 2nd time using smart service and then used PV and then indexed.

Reply Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.