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
8 replies
Subscribers
8 subscribers
Views
5461 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
merging two different data sets in a grid
Richard
over 7 years ago
I have a data store based cdt and a set of online data from another system (accessed via a!httpQuery) that I'd like to merge in a grid, is there a recipe for such an action?
Each row in the CDT may or may not have a corresponding item in the dataset taht comes back from the REST query.
OriginalPostID-242185
Discussion posts and replies are publicly visible
Parents
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
There may be a more graceful way of doing this that I'm not thinking of, but as far as I know you might need to manually aggregate field-by-field into a new CDT or dictionary in your local variable. I would suggest (mainly for sanity's sake) querying the 2 parent data types into their own local variables first, i.e. local!appianDataSet & local!httpQueryDataSet
So you might do next:
local!aggregatedData: {
fieldA: append( local!appianDataSet.fieldA, local!httpQueryDataSet.AField ),
fieldB: append( local!appianDataSet.fieldB, local!httpQueryDataSet.BField )
...
},
(then within your with()):
local!dataSubset: todatasubset( local!aggregatedData, local!pagingInfo ) ...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike Schmitt
Certified Lead Developer
over 7 years ago
There may be a more graceful way of doing this that I'm not thinking of, but as far as I know you might need to manually aggregate field-by-field into a new CDT or dictionary in your local variable. I would suggest (mainly for sanity's sake) querying the 2 parent data types into their own local variables first, i.e. local!appianDataSet & local!httpQueryDataSet
So you might do next:
local!aggregatedData: {
fieldA: append( local!appianDataSet.fieldA, local!httpQueryDataSet.AField ),
fieldB: append( local!appianDataSet.fieldB, local!httpQueryDataSet.BField )
...
},
(then within your with()):
local!dataSubset: todatasubset( local!aggregatedData, local!pagingInfo ) ...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data