The objective of this article is to compare values in a TEXT formatted line item and identify the values that occur more than once (duplicates).
Sneakerz is an up-and-coming shoe company with a variety of shoe brands in its brand portfolio. They are expanding internationally after having started from their humble origins in countryside Australia. As part of their international strategy, the marketing team is coming up with new ideas for brand names.
Sneakerz uses Anaplan for Connected Planning across the organization. The marketing team wants to enter the new brand names in Anaplan and expects Anaplan to highlight the duplicates.
For example, if ‘Comfort’ is entered on two separate rows, Anaplan should highlight the second one as a duplicate.
Final solution should look similar to the following:
The final output view indicates that there are three New Brand Names that are duplicates namely – Comfort, Ethical, Futura. On the other hand, two New Brand Names – Runner and Bambino are unique in the data set.
The limitation with this solution is that you can only identify the successive duplicates and cannot tag the first occurrence as a duplicate value too.