Find out repeating ID but different Name (other field)

[Anonymous]

Dear All

I need to find out cases where in, I have same PASS_NO but different names in Name field.

I am attaching sample data where in I need to find out the Blue colored highlighted records.

The frequency is greater than 1 in most of the entries.

Kindly help. Let me know if more details are required.

Thanks & Regards

Chintan Gala

[sunny_talwar]

You want this to happen in the script or front end of the application?

[sunny_talwar]

May be this in the script to flag those PASS NOs

Table:

LOAD [PASS NO],

    NAME,

    ADDRESS

FROM

PASS_repeat.xlsx

(ooxml, embedded labels, table is Sheet1);

Left Join (Table)

LOAD [PASS NO],

  If(Count(DISTINCT NAME) > 1, 1, 0) as Flag

Resident Table

Group By [PASS NO];

[Anonymous]

Dear Sunny

Thanks for your help.

Data is huge so is there anyway to do in front end. I have used similar expression in front end, but it does not pick all the PASS_NO which are repeating for different names.

Thanks & regards

Chintan Gala

[sunny_talwar · Accepted solution]

You can try this expression on the front end of the application:

If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, 0)

[Anonymous]

Thanks a lot Sunny, it works perfectly as required!!  If you can explain the expression a bit in brief.

In my application after applying your expression I get only repeated ones. however in your application u shared we can also see the 0 ones . Have u done any additional settings?

Thanks & regards

Chintan

[Anonymous]

Hello Sunny

I believe it is Supress zero value check box in Presentation..

[mohammadkhatimi]

This will work for both NAME and ADDRESS

If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, If(Count(DISTINCT TOTAL <[PASS NO]> ADDRESS) > 1, 1))

Hope this will helps u..!!

Regards,

Mohammad

[Anonymous]

Thanks Mohammad , this can be used for other additional reports!

[sunny_talwar]

You are right, I unchecked 'Suppress Zero Values' on the presentation tab to show 0s