Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...???
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,
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
what is alternate way to truncate duplicate EMP_DOC_NO..
any update.
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,