duplicates

[#1]

Is it possible to only display duplicate SSN out of a file?

[sunny_talwar]

Do you mean during the load you want to only include those SSN which are duplicates?

Try this:

Table:

LOAD *

FROM Source;

Right Join (Table)

LOAD SSN

Where Count > 1;

LOAD SSN,

          Count(SSN) as Count

Resident Table

Group By SSN;

[jyothish8807]

Hi Robert,

You can do this at UI level also.Load all the data, since you  may require it for other charts.

Create a straight chart.

Dimension: All the fields (Make sure suppress null value selected)

Expression:

If(Count(SSN)>1,SSN)

Regards

KC

[#4]

actually that is onlt the first check the next will be last name and first name and birthdate

[Anonymous]

Robert it would be better if you put a sample data together

[#6]

[jyothish8807]

Hi Robert,

You can create a new field which will be the combination of all the field you want to check:

eg:

Load *,

last name & first name & birthdate & SSN  as NewField

from <>

Then at UI at expression,

if(Count(New Field >1, Your required field)

Regards

KC

[jyothish8807]

Hi Robert,

Try making this expression and not dimension.

Regards

KC

[#9]

please see sample

[jyothish8807 · Accepted solution]

Load *,

rowno() as Sino,

autonumber(FacID & PatID & PatStatus & PatLName & PatFName & PatMI & Column1 & SSN & NsID & Floor & Room & Bed & BirthDate & AdmDate & DeathDate & DischargeDt) as New_field

From file.xlx;

if(Count(New Field >1, Your required field)

But QlikView will automatically identify duplicate entries. What is your actual requirement ?

Regards

KC