LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: LindaBris

Could someone help me with this: I am about to compare 2 tables using composite keys (such as FirstName and LastName). If matching, then 2nd table other columns (such as Address, State) will be brought in to 1st table. I used "left join" node, using SortLeftInput "true" and SortRightInput "true". Then I put "FirstName + LastName" as LeftInputKey, "FirstName + LastName" as RightInputKey.

I got unexpected result: (1) 2nd table other columns were not brought in (2) comparison seems not work well.

Thanks,

LindaBris

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dsc88dsc88

Hi LindaBris,

The 'Join Left' will give you the orphans from the left input, following the match.

If you use a 'Join Left Inner' you should get the results you are looking for - namely, matched records will output the additional records & any left records that do not have a right match will output NULLs.

All the best,
David

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: LindaBris

Thanks David. It works well!

Have a nice day.

Linda