Table to display duplicate values only

[julie_mita]

Hi all,

have been trying a way to filter the data in a table but have not been successful.

My table looks like the below:

I need the table to display only records with two rows or more i.e. rows for Key Field 000111 and 000112.

Have tried a few things with no luck in the data handling section such as:

if(Aggr(count( [Key Field]),[Key Field])>1,1,0)

Do you have any suggestions?

[jochem_zw]

KeyField as dimension

and as expression:

if(count(KeyField)>1, 1,0)

[balabhaskarqlik]

Try the script like this:

ABC:
Load
          [Key Field],
          Date,
          [Key Field]&Date as [New Key Field],
         Age,
         Count([Key Field]) as Counts
from abc
           group by [Key Field];

Inner Join (ABC)

BCD:
Load
         [Key Field],
         Sum(Counts) as Frequency
Resident ABC
                  Group by [Key Field];

NoConcatenate

Duplicate_Check:
Load
         *,
          If(Counts > 1, 'Duplicate Records','No Duplicates') as [Duplicate Flag]
Resident ABC
                   Order by [Key Field];

Drop table ABC;

NoConcatenate

OnlyDuplicates:
Load
          *
Resident Duplicate_Check
                   Where Match([Duplicate Flag],'Duplicate Records');

Drop table Duplicate_Check;

[julie_mita]

Thanks for your reply Jochem. 

Have tried this solution and it did not work unfortunately.

Tried converting the field to number for both dimension and measure but still no luck 😞 

[julie_mita]

So have tried this solution and it also fails... I did not mention but the table is dynamic as it is driven by a date picker filter. Depending on the selection the results will vary. 

Do you have any other suggestions?