LAE

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

Originally posted by: bradd610

Hi,

I have two different versions of the same excel file, containing contact information (ID number, Name, Email Address, etc..). However one of the versions has a more complete list of Email Addresses (as well as some of the duplicate entries deleted), whereas the other version has the Email Address missing for a large number of the contacts. Is there any way to join these files, getting the Email Addresses to match up with the correct entries using the Join Inner node? I am using the free desktop version, so that is the only Correlation join node that is available to me.

Thanks!

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

Originally posted by: ltolleson

Brad,

I have attached a simple example graph that takes 2 inputs, each having 2 fields (id and email). The id field is the key field used to match the 2 datasets, the email field contains test email addresses. The "Join Inner" node will give you an output of all rows that match by the id field in both datasets. Any records that do not match will be discarded. You can use the X-Ref node if you want to get the discarded (ie Orphaned) records. Once the join runs it puts both email addresses on the same record so that you can determine which one to use. The filter node checks to see which email is empty or NULL and uses the appropriate address. You can modify this logic to use the correct field names and get the exact email address you want, but this is a good example of how to do this.

Enjoy,
Larry
Attachments:
EmailExample.brg

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

Originally posted by: bradd610

This was perfect, just what I was looking for.

Thank you,
Brad