Remove duplicate entries in a column

Questions & Answers
1

I have a column in eazyBI which consist of numbers like (123456,678768) each of this in the string format.So I would like to highlight the duplicate entries in the entire column using cell formatting which I’m unable to do
I tried so many regex but unfortunately that doesnt seem to work.Please help me to solve this

2

Did you try the regex of:

(\d+),\1

It captures some digits and save in a “temp var” called 1, then it expects a comma and finally look for another group of digits to be the same as before

image

3

But I have these numbers in a column… that means rowwise I have to compare them. So above approach cant be used

4

Hi @Pooja_Bhat

What if just one of the numbers repeats? See example below:

For example what to do in this scenario - which tickets should be highlited? And how exactly would you highlight it in report?

ABC-13 (123456,678768)
ABC-10 (123456,678768)
ABC-11 (123456,87634)
ABC-15 (7768,123456)

Also, please share more details about the report - which dimension do you use in report rows?

Martins / eazyBI