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
21 replies
Subscribers
4 subscribers
Views
6329 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
How to join two CDT's using Process Model without using MYSQL Queries??
amitas
over 8 years ago
How to join two CDT's using Process Model without using MYSQL Queries??
OriginalPostID-219383
OriginalPostID-219383
Discussion posts and replies are publicly visible
0
amitas
over 8 years ago
@vinodb Its like I want to combine data from two CDT'S which are having one common field between them like "for ex. Id" and then storing it in a third CDT. But I am facing problem in achieving this through process model Its like details are fetched from first CDT only not from the second one. But meta data is there.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sidhant Behura
over 8 years ago
@amitas - As far I understand you want to create a new CDT from the common fields of 2 other CDTs. Do you want to create an actual CDT object/type or just an anonymous CDT.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
amitas
over 8 years ago
@sidhantb I want to create an actual CDT object/type.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sidhant Behura
over 8 years ago
@amitas - Please attach the code snippet in which you are facing the problem. It will be helpful for us to debug it.
In case you want the logic to merge two CDT's efficiently then please refer the below link.
/search?q=OriginalPostID-218216
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rodgraham
Certified Lead Developer
over 8 years ago
Depending on what you're trying to achieve using type syntax may help. e.g 'type!cdt3'( attribute1ofcdt3: ri!attribute2OfCdt1,
attribute2ofcdt3: ri!attribute3OfCdt2)
Takes attributes from cdt 1 and cdt 2 and puts into another cdt of a different type
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
I believe the post is about joining the two different CDT arrays based on a common field between them but not about merging them as said by @sidhantb above. We can actually co-relate the requirement to Joins we write in MySQL across different tables. Also I believe there isn't any code snippet written so far, the author of the post is trying to find various ways to do a join between two datasets strictly without making use of SQL. @amitas Correct me if I am wrong here.
@amitas I would suggest refraining from making such a join in process. To the best of my knowledge, you will end up in writing a code which is equally tough and complex to maintain. It might be worth giving the thoughts over trying to implement the same from database perspective as follows:
1. Dump the datasets into two different tables and read data from a view where the view is the join between two tables that you have dumped data earlier.
2. Check the possibility of writing a stored procedure that accepts two datasets as inputs and then dumps the data into temporary tables and makes join between them and then returns a resultant dataset.
Added to above, I would suggest taking a look at 'Let the Database Handle the Heavy Data-Centric Tasks' section at
http://bit.ly/28Q6T3y
which says that few actions(for instance, joining) are ideally suited to Database.
Still if you are strongly determined at implementing without making use of Database, I would suggest trying the 'CDT Manipulation' plugin as this reduces the complexity and eases the maintenance. By chance, if you intend to drive the logic by making use of expression rules and type constructors(without making use of a Plugin), then I would suggest giving thoughts over the performance in case of huge datasets and the frequency of CRs in future.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
amitas
over 8 years ago
Thanks a lot everybody.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
amitas
over 8 years ago
@rodgraham okies but where to use this in process model or interface???
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
siddharthg837
over 8 years ago
Hi @amita, not sure if you have already had a chance to look over this custom component to do various joins and other operations on different CDTs :
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
amitas
over 8 years ago
thanks all.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<
>