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