We are working on a project wherein we pull data from an external application an

gopinathreddyr over 9 years ago

We are working on a project wherein we pull data from an external application and act on this data. There might be scenarios where the data in external application might change and in-order to detect this discrepancies we have a process model that would compare both the data(Data we are working in Appian and external application data) and show all the discrepancies detected. Now we have a use case where in we need to generate a daily excel report of this discrepancies . And there might be around 1000-2000 cases that this process model need to run. Any help on how this can be achieved in Appian without performance issue is appreciated.

Discussion posts and replies are publicly visible

Parents

0 gopinathreddyr over 9 years ago

@shyamb we are on Appian 7.10 . Yes looping functions did help me to reduce the process running time. Now to run all the nodes in parallel I came up with new approach. I have created a table for this discrepancies and storing them once the comparison is done and any discrepancies found. Once we come out of the sub-process (all the cases are checked for discrepancies) I'm querying the DB and converting this to Excel. This way i could complete the whole process in 5 min when compared to Executing it one by one which took 2 hrs. Is this a good approach to follow? Any other suggestions are welcome.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 gopinathreddyr over 9 years ago

@shyamb we are on Appian 7.10 . Yes looping functions did help me to reduce the process running time. Now to run all the nodes in parallel I came up with new approach. I have created a table for this discrepancies and storing them once the comparison is done and any discrepancies found. Once we come out of the sub-process (all the cases are checked for discrepancies) I'm querying the DB and converting this to Excel. This way i could complete the whole process in 5 min when compared to Executing it one by one which took 2 hrs. Is this a good approach to follow? Any other suggestions are welcome.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data