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
7 subscribers
Views
2521 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hello all, Suppose i get a data from a query rule let's call it l
satyasheel
over 11 years ago
Hello all,
Suppose i get a data from a query rule let's call it local!datasubset1, again i get a different data from query rule say local!datasubset2. now the question, is there any way i can merge these two local datasubsets to get a one local datasubset say local!datasubset
Thanks,...
OriginalPostID-99253
OriginalPostID-99253
Discussion posts and replies are publicly visible
0
Tim
Certified Lead Developer
over 11 years ago
If they are of the same type then you can just use "local!dataArray: {local!datasubset1, local!datasubset2}" and so access them as a data array.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
satyasheel
over 11 years ago
hello Tim,
it's not working
i am getting data which is a DataSubset from two different protal report(these two reports only differ in number of data they contain)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 11 years ago
Try: local!dataArray: {local!datasubset1.data, local!datasubset2.data}
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
satyasheel
over 11 years ago
it worked!! thanks,
but again how do i change local!dataArray to DataSubset. Tried todatasubset() but it's not working.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 11 years ago
This works for me:
= load(
data1: rule!qGetIncidentNested(4863991),
data2: rule!qGetIncidentNested(4863660),
data3: {data1,data2},
todatasubset(data3)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
satyasheel
over 11 years ago
sorry i forgot to mention that i am getting datasubset by quarrying portal report i.e i am retrieving all the data from portal report, with same method i am getting second datasubset from second portal report, now taking these two datasubset how i merge them to a single datasubset.
Tim that previous method you suggested is not working, i.e for given datasubset ".data" is empty so here merge works fine, but i want to merge is ".report" subpart of datasubset.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Dan
over 11 years ago
I have a similar use case. I would like to merge the results of 2 separate reports executed in Appian to display in a single grid.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel