Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Mark only duplicates, not the first occurance


This topic is 7847 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi folks,

I can't remember for the life of me how to script this: I want to have a calculated field that DYNAMICALLY marks only repeating duplicate records, not the first occurance of the dup.

For innstance: Case(Count(SelfJoin::ID)>1, 1, "")

This will mark all of the dups with 1, but I want to mark only the repeating ones. I'm aware of the script that does that, but I need to do this with calculated field as it must be dynamic.

Thanks for the advice

B

Link to comment
Share on other sites

Thanks Ugo, but it didn't work for me. This tags all of the records as 1, which is to be expected.

I guess I have the same problem as jasonwood from the thread you provided:

It seems to me that both of the duplicates would have a valid self relationship to eachother, so wouldn't they both get tagged?

Link to comment
Share on other sites

Perhaps (and I haven't tested this) you could create a field that auto-enters an "X" (or some alert) if the self-join count is greater than one. That way, the first entry wouldn't enter the "X", but subsequent ones would.

I'm not sure how "dynamic" you need, since a record is either a dup when it's created or it isn't.

Link to comment
Share on other sites

Hi,

It should work, but change it to

c_checkdupes = Case(Record_Id = SelfjoinOntheFieldYouwantToCheck::Record_Id, " ", 1) if you wish

Record_Id = the serial

Selfjoin = Name::Name (this isn't the best example, but...).

I use it everyday !!!

Link to comment
Share on other sites

This topic is 7847 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.