Data360 Analyze

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.

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

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

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.