We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Union or Concatenation

Comments

3 comments

  • Avatar
    Stony Smith

    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)

    0
    Comment actions Permalink
  • Avatar
    Meng Gao

    Thank you Stony! This is very helpful!

     

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk