Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mapratt82
New Contributor III

Same SSN w/multiple similar name issue

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.

1 Solution

Accepted Solutions

Re: Same SSN w/multiple similar name issue

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

2 Replies

Re: Same SSN w/multiple similar name issue

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
New Contributor III

Re: Same SSN w/multiple similar name issue

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