Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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;
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)
Something like this?
Something like this?
@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