Hi Experts,
Earlier we were using Export SQL to Excel for generating the Excel from the db having 387 columns.
This particular service has got deprecated, how can we get this undepreciated or if there is any other workaround to generate the same.
Tried using Export Data Store Entity to Excel but it not working beyond 50 columns, when trying to break the colomn into set of 50 and then trying to right in next 50 column the previous column data is getting deleted.
Discussion posts and replies are publicly visible
Do you mean 387 rows? Or do you honestly mean that each row contains 387 named data elements?
Its 387 columns David, rows are more than 50K.
Export data store entity to Excel have limitation of 50columns hence can't use that smart service.
Also to confirm, is this a one-time data load, or are you building a process to import this massive excel file regularly?
Yeah having some more information would be helpful for us here. Why do you need all those columns? What are you doing with the data? There are other ways of getting data out of Appian that may be better depending on your use case.
Also, I was thinking regarding your other thread of importing this massive file. Will a CSV export not suffice? But yes, more details the better.