Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to create a field to flag duplicate on a straight table the field is a concatenation of 3 fields I do no have access to the back end (Script) to make change on the data model so I am using this code it woks on just on field but on multiple field concatenate
=if(count(total <ID&Tradedate&Tranno>ID&Tradedate&Tranno)> 1,'Duplicate','unique')
@Geostidet just a little change required
=if(count(total <ID,Tradedate,Tranno> ID&Tradedate&Tranno)> 1,'Duplicate','unique')
@Kushal_Chawda thanks so much is it a way to flag the highlighted rows as duplicate regardless of the type or dir just taking in consideration ID&Tradedate&Tranno
@Geostidet just a little change required
=if(count(total <ID,Tradedate,Tranno> ID&Tradedate&Tranno)> 1,'Duplicate','unique')
@Kushal_Chawda thanks so much is it a way to flag the highlighted rows as duplicate regardless of the type or dir just taking in consideration ID&Tradedate&Tranno
@Geostidet Yeah. It should.
Since you are already grouping by the three fields, I think this could be simplified to count just a single field.
=if(count(total <ID,Tradedate,Tranno> ID)> 1,'Duplicate','unique')
-Rob