Highlight Duplicate rows including first one

Yashabh
Occasional Contributor

Highlight Duplicate rows including first one

Hi All,

 

I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd  duplicate row. I am using Concatenation to check duplicates within a unique key of 4 line items.

Would be great if someone can help with this.

 

Thanks!! 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
TonyViGrand
Occasional Contributor

Re: Highlight Duplicate rows including first one

@Yashabh 

 

I have seen a similar post which could help.

Solved: Re: Count Duplicates Based on Text Field - Anaplan Community

 

The rows in Duplicates line item which have number more than 1 are the duplicates. I have shared screenshots which could help you too.

TonyViGrand_0-1616488835938.png

TonyViGrand_1-1616488869693.png

Hoping this will solve your problem.

 

Tony Grand

 

View solution in original post

8 REPLIES 8
rob_marshall
Moderator

Re: Highlight Duplicate rows including first one

@Yashabh 

 

Can you give us an example? 

Yashabh
Occasional Contributor

Re: Highlight Duplicate rows including first one

@rob_marshall  we have an module with 2 text formatted and 2 list formatted line items which will accept data using Excel Add in. I am exploring an option to highlight all duplicates (including the first one) without users having to trigger an action. 

alexpavel
Certified Master Anaplanner

Re: Highlight Duplicate rows including first one

@Yashabh  a way to do it is to create a list from the concatenation of the 4 line-items and create a summary in a module using this list from a numeric line-item with formula =1 on the source module. 

 

doubles will be the ones with the sum being  >1. 

 

 

Yashabh
Occasional Contributor

this Re: Highlight Duplicate rows including first one

@alexpavel  I did explore this option but we are using Excel Add in to submit data. Clicking the Action button to trigger Import to the list would be an additional manual activity, which i am trying to avoid. However as a last option would go with it.

alexpavel
Certified Master Anaplanner

Re: this Re: Highlight Duplicate rows including first one

@Yashabh Indeed.. it is needed to trigger an action to have this work calculated in Anaplan. 

 

not very much familiar with Anaplan Excel Add-In...but can't you combine Excel formulas to highlight the duplicates using Excel potentiality? 🙂

CommunityMember126793
Regular Contributor

Re: this Re: Highlight Duplicate rows including first one

@Yashabh , applied the check with the boolean and uses number format line item to pick the reoccurrences to highlight..

Below screen print for reference:

CommunityMember126793_0-1616150934239.png  CommunityMember126793_1-1616151021679.png

 

Let here know if this will help or not

TonyViGrand
Occasional Contributor

Re: Highlight Duplicate rows including first one

@Yashabh 

 

I have seen a similar post which could help.

Solved: Re: Count Duplicates Based on Text Field - Anaplan Community

 

The rows in Duplicates line item which have number more than 1 are the duplicates. I have shared screenshots which could help you too.

TonyViGrand_0-1616488835938.png

TonyViGrand_1-1616488869693.png

Hoping this will solve your problem.

 

Tony Grand

 

View solution in original post

Yashabh
Occasional Contributor

Re: Highlight Duplicate rows including first one

This worked!!

 

Great Solution @kevin.cho 

Thanks for referencing @TonyViGrand