Any workaround for MNI limit of 1000? Need to process 10,000+ records from

Jess over 9 years ago

Any workaround for MNI limit of 1000?
Need to process 10,000+ records from CSV file and save it to database,but beforehand,it needs to process complex task ex. Generate/plot planned completion date based on milestones (7) and received date.. I don't think looping functions can be used here since there are lots of Database and Query rule interaction as part of the process. The records from CSV will be saved as the parent record and the generated data from each record as the child (1:M). Please advise. TIA.

Discussion posts and replies are publicly visible

Parents

0 Christine
Appian Employee
over 9 years ago

One idea to try:
Utilize the read excel spreadsheet utility (from shared components). Put the data into a temp table. Then execute a stored procedure to perform the calculations that you need and populate table(s) that you need. You can then pull data back into process as needed.
I'm not sure how much of this meets your use case. But hopefully this gives you a few ideas.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Christine
Appian Employee
over 9 years ago

One idea to try:
Utilize the read excel spreadsheet utility (from shared components). Put the data into a temp table. Then execute a stored procedure to perform the calculations that you need and populate table(s) that you need. You can then pull data back into process as needed.
I'm not sure how much of this meets your use case. But hopefully this gives you a few ideas.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data