-
1. Re: Identify Duplicates with Calculated Fields
Mark BradbourneOct 27, 2017 8:15 AM (in response to ferdaws.mahmody)
Try this LOD
IF { FIXED [Name] : SUM([Number of Records]) } > 1 Then "Yes"
Else "No"
END
-
2. Re: Identify Duplicates with Calculated Fields
ferdaws.mahmody Oct 27, 2017 8:25 AM (in response to Mark Bradbourne)Hi Mark,
thanks for the reply.
The LOD is "valid". However, it returns "Null" only.
-
3. Re: Identify Duplicates with Calculated Fields
lenaic.ridinger Oct 27, 2017 8:26 AM (in response to ferdaws.mahmody)Hi ferdaws.mahmody,
It sounds like a mission for LOOKUP
Something like:
IF NAME = LOOKUP([NAME]),-1
THEN PREVIOUS_VALUE(1)+1
ELSE 1
END
Have a look at this thread, it's an interesting guide about how to do this: How to identify duplicates
If you need more assistance, let me know
----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
-
4. Re: Identify Duplicates with Calculated Fields
ferdaws.mahmody Oct 27, 2017 8:33 AM (in response to lenaic.ridinger)Hi Lenaic,
actually, I am looking for sth. like the the LOD Mark suggested:
Not sure why it returns "Null".
Thank You.
-
5. Re: Identify Duplicates with Calculated Fields
Deepak RaiOct 27, 2017 8:45 AM (in response to ferdaws.mahmody)
-
Duplicates.twbx 14.8 KB
-
-
6. Re: Identify Duplicates with Calculated Fields
ferdaws.mahmody Oct 27, 2017 9:59 AM (in response to Deepak Rai)Thank you. You also have "Null" in the Data Set. However, I Need the "Yes" and "No" in the data set as I would like to do further Operations in that calculated field.
-
7. Re: Identify Duplicates with Calculated Fields
Deepak RaiOct 27, 2017 10:01 AM (in response to ferdaws.mahmody)
-
8. Re: Identify Duplicates with Calculated Fields
Mark BradbourneOct 27, 2017 10:06 AM (in response to ferdaws.mahmody)
Add a Null check (try this)
IF ISNULL({ FIXED [Name] : SUM([Number of Records]) }) Then 'No'
ElseIF { FIXED [Name] : SUM([Number of Records]) } > 1 Then "Yes"
Else "No"
END