How to remove duplicate values in If Statement expressions

[saivina2920]

i have the below records. i just want to remove the duplicate values of EMP_DOC_NO.

below is the screenshot.

DIM-1: 

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE), EMP_RESIGN_DATE), if(not IsNull(EMP_RELIEVE_DATE), EMP_RESIGN_DATE))

DIM-2:

=EMP_DOC_NO

Expr-1: (Relieving_Date)

=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]), Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull([EMP_RELIEVE_DATE]), EMP_RELIEVE_DATE))

Expr-2: (1-10days)

If([Relieving_Date]>=vCalDate10 And [Relieving_Date]<=vToday, 1,0)

Expr-3: (10-30 days)

If([Relieving_Date]>=vCalDate30 And [Relieving_Date]<=vCalDate10, 1,0)

How to remove the duplicate values  in the above expressions...???

[QFabian]

Hi @saivina2920 , check that you have another fields in that table : Emp Reg Date Relieving_Date, and they have diferent values, so, the value for EMP_DOC_NO, its going to be repeated because of the relation with the others fields

[saivina2920]

what is alternate way to truncate duplicate EMP_DOC_NO..

[saivina2920]

any update.

[Chanty4u · Accepted solution]

Hi ,

this is because of    emp reg date or relieving date  

as there is 3 dates for   EMP-004   thats y its shwoing duplicate in the data,