Count of duplicate

Help Activities
, ,
1

Hello All,
I have two excel files in which one file has policy numbers with duplicates and other with unique values. So I need to count the policy numbers in duplicate file. Please help me with this.

2

Hi @ISBS_ROBOT

Can you provide some sample excel file then it will be helps

3

Hi @ISBS_ROBOT,

I assume that both files have a column for the Policy Number?

You can try reading both files and then iterating through them. Please see the below pseudo as an example:

For Each OuterRow in Table1: // This would be your file of unique ones
	For Each InnerRow in Table2: // This would be your file of duplicates
		If OuterRow("Policy Number").ToString = InnerRow("Policy Number").ToString:
			Then:
				MatchingCount = MatchingCount +1 // This is your integer for counting duplicates
				Break
			Else:
				Do Nothing
4

Corp_Filter.xlsx (227.8 KB)
Sheet Output has Policy No and the same within Sheet1. Calculate the count of that policy numbers

5

@ISBS_ROBOT

can you explain more what you want

dt1.AsEnumerable.Select(Function(x) x(“POLICYNO”).ToString).ToArray.count

dt2.AsEnumerable.Select(Function(x) x(“POLICYNO”).ToString).ToArray.count

gives you the count

cheers

6

Hi @ISBS_ROBOT

Please find the below xaml

BlankProcess11.zip (259.5 KB)

Hope this helps!!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.