Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
8 subscribers
Views
2740 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi everybody, We are looking for advices/best practices prior to deve
fabienb
A Score Level 1
over 11 years ago
Hi everybody,
We are looking for advices/best practices prior to develop an application around data manipulation. Among the requirements, we need to:
- create a table from an excel file
- improve data quality using matching alogrithm
- display the matching result and get approvals from users
The expected number of input rows is around 10k+ but the number of distinct "matching" is more about a couple of hundreds I suppose.
For now, we have been thinking at the following solutions :
1- To create the table : use the excel file plugin + create CDTs + use write to data store entity Smart Service
2- To perform the matching, we have a custom expression that works just fine
3- To display distinct matchings: use the Query Database Smart service (SELECT DISTINCT... ) + create CDTs + use of paging grids for display
We encounter some limitations for 1&3 (nodes limit (1000), number of max rows returned by a query (10), latency) and prior to move on custom...
OriginalPostID-57770
OriginalPostID-57770
Discussion posts and replies are publicly visible
Parents
0
fabienb
A Score Level 1
over 11 years ago
... solutions, we are really eagger to hear your insights on what would be the best design and what workarounds could be found on those limitations.
Thank you very much!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
fabienb
A Score Level 1
over 11 years ago
... solutions, we are really eagger to hear your insights on what would be the best design and what workarounds could be found on those limitations.
Thank you very much!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data