Data360 Analyze

 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.