Comparing 2 columns and then finding duplicates

[amitvermancl]

Hi All,

I have 2 columns A & B, ideally they should have one to one mapping that is a entry in A should occur only once in B.

But in my case, the same entry is repeating multiple times in B, so I need to find the count of how many such duplicates are happening and count of duplicate entries (as in current example 1 is coming 3 times in B, 2 is repeating 4 times)

A	B
1	1
2	1
3	1
4	2
5	2
6	2
7	2
8	9
9	9
10	9

[Saravanan_Desingh]

One solution is.

tab1:
LOAD * INLINE [
    A, B
    1, 1
    2, 1
    3, 1
    4, 2
    5, 2
    6, 2
    7, 2
    8, 9
    9, 9
    10, 9
];

Left Join(tab1)
LOAD B, Count(B) As CntB
Resident tab1
Group By B;

[Kushal_Chawda]

tab1:
LOAD * INLINE [
    A, B
    1, 1
    2, 1
    3, 1
    4, 2
    5, 2
    6, 2
    7, 2
    8, 9
    9, 9
    10, 9
    11,5
];

With column B as dimension you can use below expression

=Count({<B={"=count(B)>1"}>}B)

[nevilledhamsiri]

Something like this?

[nevilledhamsiri]

Something like this?

[Brett_Bleess]

@Kushal_Chawda , @Saravanan_Desingh  Hey guys, I suspect the notification issue may have caused you not to see the updates on this one, so just wanted to let you know, I think it better to let you guys chime in again versus me trying to help given it is Development related, and we know that is not my strong area! 🙂

Cheers,
Brett