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
7 replies
Subscribers
8 subscribers
Views
3160 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I have a complex case that I need help with that will probably end up in a store
reginaldm
over 8 years ago
I have a complex case that I need help with that will probably end up in a stored procedure of some sort.
Here's an example: From your query entity, you retrieve 100 rows of data, many of them all containing the same information, except for 1 column, for the following 4 columns:Application #, Part Time Students, Full Time Students, School Number
Your data looks like this initially:
(The count matches for each set = 7)
Application #: {115111,115112,115113,115114,115116,115117,115118}
Part Time Students: {1000,2000,1000,2000,1000,1000,2000}
Full Time Students: {500, 500,1000,500,1000,1000,1000}
School #: {1,2,1,2,1,2,1}
From here, you want to retrieve only distinct values from each set (this may even include nulls at any given point).
So you want to truncate your data to this since there are many duplicates:
Application #: {115111,115112,115113,115114,115116,115117,115118}
Part Time Students: {1000,2000}
Full T...
OriginalPostID-193992
OriginalPostID-193992
Discussion posts and replies are publicly visible
Parents
0
Eliot Gerson
Appian Employee
over 8 years ago
Can you please explain your use case a bit more? Is there a particular reason for taking this approach?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eliot Gerson
Appian Employee
over 8 years ago
Can you please explain your use case a bit more? Is there a particular reason for taking this approach?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data