Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Union or Concatenation

    Employee
    Posted 02-27-2019 15:29

    There are two datasets that have common columns and individual columns. Two data sets don't have same keys connected. I just want to concatenate or union two datasets into one dataset. Is there any "Union" or "Concatenate" node to achieve this? I tried merge or join node that don't work because there is no common key in two data set. 



  • 2.  RE: Union or Concatenation

    Employee
    Posted 02-27-2019 20:13

    Use the CAT node with the UNION option.. you'll get the two recordsets end-to-end with the common columns populated, and NULL in the non-common columns (or use the INTERSECTION option if you want to actually drop the non-common columns)



  • 3.  RE: Union or Concatenation

    Employee
    Posted 02-28-2019 15:28

    Thank you Stony! This is very helpful!

     

     



  • 4.  RE: Union or Concatenation

    Employee
    Posted 03-26-2019 05:08

    The node search functionality was enhanced in release 3.4.0 to allow you to use common terms to find nodes. So, for example, you can now enter "union" or "concat" and the results will identify the Cat node.