http://m.getsatisfaction.com/topics/7664836 Union Datasets Together Bionic Rule 2018-08-10T19:58:56Z 2018-01-09T22:23:56Z 7664836 http://m.getsatisfaction.com/topics/7664836 7664836 Union Datasets Together Bionic Rule 2018-08-10T19:58:56Z 2018-01-09T22:23:56Z Dallis King http://m.getsatisfaction.com/people/9120092 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11108874/dahlia-red-blossom-bloom-60597_medium.jpeg dallis_king I have two datasets, in which a few of the rows will be identical between the two. I'm trying to create a bionic rule that performs different actions if the row in first dataset matches a row in the other rather than if the row is unique.&nbsp;<br /><br />My original thought was to union the two datasets together, transform them and add a counter for how many times the identifying values match. Then I can create actions off of count = 1 vs count &gt; 1.&nbsp;<br /><br />But I can't seem to figure out how to union these two datasets together. When I do a merge step, it tries to combine the rows and I can't seem to get them to just union together. They have the same column names.<br /><br />Is there a way to union two datasets together? Or is there another way anyone can think of to achieve this result? question active 4 7 2 comment http://m.getsatisfaction.com/topics/7664836/replies/19227743 http://m.getsatisfaction.com/topics/7664836 19227743 Dan Ahrens responded to "Union Datasets Together Bionic Rule" 2018-01-10T06:00:21Z 2018-01-10T06:00:21Z Dan Ahrens http://m.getsatisfaction.com/people/8169071 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10797429/dan-ahrens_medium.jpg dan_ahrens Hi Dallis. I'm sure there are a couple different ways to tackle this but here is a thought I had. This would involve the type of merge and output field labels.&nbsp;<br /><br />Let's say that your data was super simple and just consisted of&nbsp;<b>Account Name&nbsp;</b>and&nbsp;<b>Contact Name</b>.&nbsp;<br /><br />The first step is to look for instances where the data in dataset 1 matches any data in dataset 2. Perform a merge where you "Retain all records from left dataset" (dataset 1 is left, dataset 2 is right), using both fields in the "Map to" criteria. <br /><br />In the&nbsp;<b>Output Field Label</b>, for dataset 2 check the box for Account Name and rename the field to "Match". If the two datasets match, the Account Name field will have data. If a given row in dataset 1 does not have a match in dataset 2, the Account Name field will be blank. This will give you all records from dataset 1 and indicate if any of those records have a match in dataset 2.<br /><br />Now we just need to add the records in dataset 2 that did not match. Merge the output of the first merge with dataset 2 and "Retain all records from both datasets", using both fields in the "Map to" criteria.&nbsp;<br /><br />You will have kept all records from the first merge, with a field that would identify a match (which could be used later for filtered actions, etc) along with any unmatched records from the second dataset.&nbsp;<br /><br />Let me know if this works for you! 0 http://m.getsatisfaction.com/topics/7664836/replies/19227882 http://m.getsatisfaction.com/topics/7664836 19227882 Nitin Pawar responded to "Union Datasets Together Bionic Rule" 2018-01-10T08:33:55Z 2018-01-10T08:33:55Z Nitin Pawar http://m.getsatisfaction.com/people/9241491 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11125156/photo_medium.jpg nitin_pawar_76hedt4szbv1b Hi Dallis,<br /><br />We are in process to ship Data Union as new task type. It was planned as part of last release but we could not ship it.&nbsp;<br /><br />We will try to ship this asap<br /><br />Thanks,<br />Nitin 0 http://m.getsatisfaction.com/topics/7664836/replies/19592944 http://m.getsatisfaction.com/topics/7664836/replies/19227882 19592944 Jean Nairon responded to "Union Datasets Together Bionic Rule" 2018-06-20T06:00:50Z 2018-06-20T06:00:50Z Jean Nairon http://m.getsatisfaction.com/people/9687494 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11284106/photo_medium.jpg jean_nairon_ks9korjb1o1zj Is there any update on when Data Unions will be available? Your post was 5 months ago and I don't think this feature is available yet. 0 http://m.getsatisfaction.com/topics/7664836/replies/19689468 http://m.getsatisfaction.com/topics/7664836/replies/19227882 19689468 Matthew Lind responded to "Union Datasets Together Bionic Rule" 2018-08-10T19:58:56Z 2018-08-10T19:58:56Z Matthew Lind http://m.getsatisfaction.com/people/7547391 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10542606/photo_medium.jpg matthew_lind Nitin and team, any updates on Union task type within Bionic Rules? I have a solid use case for Union: I conducted a survey for the first half of 2018, and now I'm conducting an almost identical survey for the second half of 2018, and I want to bring in rows from each survey (but not Merge or Join them). 0