Duplicate Scenarios

[Anonymous]

Hi,

I am interested in showing multiple duplicate scenarios in the file.

E.g

Duplicate of combination of same invoice num + same vendor num + same amount

Combo of same invoice num + invoice date

Combo of same invoice num + vendor num

So, for the first one I had concatenated the above mentioned fields and called it as the following

     [Invoice Number] & [Vendor Number] & [Payment Amount] as C_Duplicate,

now to show the duplicate records I created a listbox with the formula

=if(Count(C_Duplicate) > 1, 'T', 'F') but I am not getting the desired result.

Basically I want a table/chart showing all the potential duplicate records from all the scenarios.

Attached the sample format of how I the result is expected

[effinty2112]

Hi Digvijay,

This script

DataWithAutoID:

Load

*,

AutoNumber([Invoice Num] & '|' & [Vendor Num] & '|' & [Invoice Amount],'AutoID1') as AutoID1,

AutoNumber([Invoice Num] & '|' & [Vendor Num] & '|' & [Invoice Amount],'AutoID2') as AutoID2,

AutoNumber([Invoice Num] & '|' & [Vendor Num] & '|' & [Invoice Amount],'AutoID3') as AutoID3

Resident Sheet1;

Drop table Sheet1;

gives a unique number ID for each of the combos you're looking for duplicates in.

Below is a straight table with no expressions with the option "suppress zero values unchecked". the first three columns are calculated dimensions. The first is:

=If(Aggr(Count(AutoID1), AutoID1)>1,'Yes')

Dup AutoID1	Dup AutoID2	Dup AutoID3	Invoice Amount	Invoice Date	Invoice Num	Serial_No	Vendor Num
			1000	3/3/2015	111	3	987
			2000	3/3/2015	111	4	7665
Yes	Yes	Yes	2000	5/20/2016	123	1	1234
Yes	Yes	Yes	2000	5/20/2016	123	2	1234
			8000	10/11/2013	222	6	566
			9000	9/9/2014	222	5	566

All the best

Cheers

Andrew

[Digvijay_Singh]

Right, this one has improved scripting

Now Sunny can take best of all.

[Anonymous]

Thanks all, appreciate all your help

[Anonymous]

Thanks Andrew, appreciate it