Join (Superseded) Node Full out join

Follow

Jerome Walker

• January 02, 2020 17:14

Is it possible to join two nodes with the join (superseded) node?  I understand how to write SQL coding, but I am not sure how to write the code for the nodes I am trying to join.  For example,

1. SELECT C.FirstName, C.LastName, C.Country AS CustomerCountry,
2. S.Country AS SupplierCountry, S.CompanyName
3. FROM Customer C FULL JOIN Supplier S
4. ON C.Country = S.Country
5. ORDER BY C.Country, S.Country

How do you replace the "Customer C" and "Supplier S" with Data3sixty coding?  I understand that you pull in the columns through the input fields, but I'm not sure about the actual node itself.

0

• 

  Stony Smith

  • January 03, 2020 18:57

  Let's assume that you connected the Customers to pin1 and the Suppliers to pin2
  
  LeftInputKey = Country
  RightInputKey = Country
  
  emit 1:FirstName, 1:LastName
  emit 1:Country AS CustomerCountry
  emit 2:Country AS SupplierCountry
  emit 2:CompanyName

   

  1

  Comment actions Permalink
• 

  Jerome Walker

  • January 03, 2020 19:18

  Thanks for your help with my join problem.  Is this BrainScript language?  I ask because I usually code in python.

  0

  Comment actions Permalink
• 

  Stony Smith

  • January 03, 2020 19:44

  Yes.. the (Superseded) node(s) use BrainScirpt.
  If you use the new Join.. you'd use the dropdowns to select and/or rename the fields going to the output.

  0

  Comment actions Permalink

Please sign in to leave a comment.