Discussion board where members can get started with Qlik Sense.
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.
Go to 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
Thanks! I had a little trouble getting it set up, but once I figured out the syntax it worked perfectly. Thanks again!