Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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
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.
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
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.
Thanks a lot for very crisp and clear explanation