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 TIA,
How big the table is ? I would say that you can do the following.
I would use a stored procedure and use another table and a process to do that. I would call it Staging or something similar. That way you kind of freeze the table data.
If you need information like the Appian group name I would use another table so you can make a join or update that staging table.
1) copy data (select insert) inside a SP
2) get Appian information and insert into a table
3) update your copied data
4) (export) use the out of the box Data Entity to Excel.
Hope this helps
Jose
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.