Same SSN w/multiple similar name issue

[mapratt82]

I'm needing to have a table that will combine all the information with the same SSN and give only one name and total.

Example: ssn 999 99 9999  name John Smith  acct total $500 and  ssn 999 99 9999   name John C Smith  acct total  $600

Returns: ssn 999 99 9999 name John C Smith  acct total $1100

Thanks in advance.

[Colin-Albert · Accepted solution]

Create a 2-column mapping table with SSN & Name columns, and use Applymap in your load script to link an SSN to a name.

Applymap will only return the first matching value so you will always get the same name returned.

Don't join - use Applymap instead

[mapratt82]

Thanks! I had a little trouble getting it set up, but once I figured out the syntax it worked perfectly. Thanks again!