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

Shyam, Thankyou for the reply. Comparison logic is little complex as it need to go through lot of data that need to be compared. Ideally each comparison would take 30-40 sec .I had a test run on around 300 cases and it took around 2 hours to complete. I tried to run the nodes in parallel but I couldn't figure out way to store the discrepancy data of every case into a single CDT which is used to export to excel. I wanted to reduce this time of processing.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 gopinathreddyr over 9 years ago

Shyam, Thankyou for the reply. Comparison logic is little complex as it need to go through lot of data that need to be compared. Ideally each comparison would take 30-40 sec .I had a test run on around 300 cases and it took around 2 hours to complete. I tried to run the nodes in parallel but I couldn't figure out way to store the discrepancy data of every case into a single CDT which is used to export to excel. I wanted to reduce this time of processing.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data