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.