Matching values

[Anonymous]

Hello,

I have one question. I have 12 digit numbers. I want to create a new field for the numbers who have  more than 8 digits the same. Is this possible in qlik sense?

[wdchristensen]

I am not sure I understand what you are trying to do.

Are you saying I have 2 data sets like customer information from Sprint and T-Mobile where the primary keys from the datasets don’t align so you are trying to join them on phone number where one may have the area code included and the other doesn’t?

Sprint                   

ID            Name    NumberOfDevices          PhoneNumber

123         Will         4                                              1119995555

456         Joe         2                                              1112223333

TMobile                              

Key        Name    NumberOfDevices          PhoneNumber

ABC        Bill          2                                              9995555

DEF        Mike       3                                               9994444

Desired outcome:

Derived Name, Total Devices

Will/Bill, 6

Joe, 2   

Mike, 3

[wdchristensen]

Should the below return true or false and why?

145687432146

456874321461

[wdchristensen]

You might be looking to perform an Exclusive-OR

XOR -- from Wolfram MathWorld

You could do this for each character and add number of matches and take those with a value is 8 or greater and give it a true value. So to answer you original question. “Is it possible in Qlik?”, I am most certain it can be done in qlik but you may struggle to implement a solution. 

[Anonymous]

What I am trying to do is : 

I want to have the similarity to ID numbers and Firstname and Lastnames. If more than two clients have the same ID( for example 9digits out of 11 is the same ) and also Firstname and lastname is the same, it is more chance that this client should be duplicated, so I want to have these clients on another table.