Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks! I had a little trouble getting it set up, but once I figured out the syntax it worked perfectly. Thanks again!