Set analysis

Anonymous — Thu, 05 Jul 2018 16:05:01 GMT

Hi guys,

Could you please help me with the below expression, what it does?

num(

Count({<[ID SCD duplicate]={"=Count([ID SCD duplicate])>1"}>}[ID SCD duplicate])

,'# ##0')

Re: Set analysis

vishsaggi — Thu, 05 Jul 2018 16:18:24 GMT

It is counting the number of duplicate values your each field value of [ID SCD Duplicate] field has. So for ex:

From the below sample data:

File:

LOAD * INLINE [

File, ALL

C571, R

C571, NR

C569, R

C869, R

C869, NR

C1806, R

];

If you do count(File) you will get : 7

If you do Count({< File = "=Count(File) >1"} >} File) you will get : 5

- So here it is counting only those values which has count >1.

If you do Count(DISTINCT {< File = "=Count(File) >1"} >} File) you will get : 2

- So here it counts the number of field unique field values that has duplicates. There are two values C571 and C869 which have duplicates.

Hope this makes sense.

Anonymous — Thu, 05 Jul 2018 17:20:22 GMT

Thanks a lot for very crisp and clear explanation