Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi Everyone
I'm currently facing an issue while exporting data from a specific table that contains more than 50 columns. I'm using the Export Data Store Entity to Excel plugin, but it throws an error during the export process.
Has anyone encountered a similar issue or found a workaround to export data with more than 50 columns successfully? Any suggestions or guidance would be greatly appreciated.
Thanks in advance!
Discussion posts and replies are publicly visible
As Mike suggested, there is a smart service limit of 50 columns.
I often encounter requirements where I need to export more than 50 columns. To handle this, I create multiple sheets, each containing a set of 50 columns.
Here I initialize first column of each sheet with the same unique identifier, which makes it easy to put VLOOKUP later to work in downloaded excel.
For example:
I pass the same document for update across all sheets. Hope this helps!
Its Not Working going the above approach and old data erasing
Are you using a new sheet when you re pass to smart service for next set of columns?If you use the same sheet then it will overwrite the existing data.Can you share your configurations of both the smart service nodes and process flow diagram?
Are you going with a new sheet or going with the 51st column of the original sheet?
As far as I know the data only gets overwritten in rows underneath columns you actually write into, though I'd have to double check. If it's clearing data in other columns anyway, then you'd need to consider Harsh's suggestion of using an additional sheet. If you're writing to a second sheet and THAT is clearing data in the first sheet, then I'd consider that a bug which you should report. But we'll need some more details here either way.
(I tested myself and confirmed that the data on the same sheet IS cleared, but if you write to a new sheet, it's fine).
It works perfectly when updating different sheets within the same file. However, when updating an existing sheet, the old data gets overwritten, and the new data is inserted starting from the specified cell position .My Requirement is I Need to update in same file
The only other thing I can suggest (if you ABSOLUTELY MUST generate more than 50 columns) is the alternate approach I outlined already in my top comment above.
Glad to hear you've achieved it! Could you explain the challenges you or your business are facing with this approach? This method allows you to use VLOOKUP across multiple sheets or consolidate data into a single sheet. Realistically, no one works with more than 50 columns at a time, so I'm curious, what specific difficulties are you encountering with this setup?