Hi all,
I have a process which uses Export SQL to Excel Smart Service and fetches data from the db and creates a excel sheet. But before creating the excel, I need to manipulate the data and then pass it to the excel.
For example: My DB column is in number and I need to apply a function in Appian to get a group from this number and then create the excel from this manipulated data.
Any suggestions?
TIA!
Discussion posts and replies are publicly visible
Hello apoorvam,
You may do all the data manipulations at the database level and then call the stored procedure in Export SQL to Excel smart service.