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

gopinathreddyr over 8 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 Shyam Bommakanti
Certified Lead Developer
over 8 years ago

Using with(), looping functions, query entity, you can achieve complex data processing. I suggest creating the rule(s) with the same logic as process model. You can define local variables and get append your results to it. Give it a shot.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Shyam Bommakanti
Certified Lead Developer
over 8 years ago

Using with(), looping functions, query entity, you can achieve complex data processing. I suggest creating the rule(s) with the same logic as process model. You can define local variables and get append your results to it. Give it a shot.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data