How to identify duplicate text in lineitem to buila a unique list?

Friends, need your input and help in meeting the below scenario where I have a module n Dimension (IDs) and few listtype line items. There are repeated values if I concatenated line items (fyi in Anaplan; NAME(A) + NAME(B) + NAME (C) + NAME(D)) and need a unique list from those concatenated values.

Tried RANK but can't use given the base line Item is TEXT and nor use ISFIRSTOCCURENCE due to don't have any concatenated list.

If I build a concatenated then it will be Numbered but still need a unique list.

need way to sort this out

Accepted answers

mburdak

Hi,

This is the exact use-case for ISFIRSTOCCURENCE(), I think you have misunderstood the function.

You don't need the concatenated list for this. Your formula will be ISFIRSTOCCURRENCE(Concatenated Values, ID List) , where 'ID List' is the list with 'ID1', 'ID2',.... as members.

See the example here: ISFIRSTOCCURRENCE - Anaplan Technical Documentation

Regards,

Mandeep

All comments

mburdak

Hi,

This is the exact use-case for ISFIRSTOCCURENCE(), I think you have misunderstood the function.

You don't need the concatenated list for this. Your formula will be ISFIRSTOCCURRENCE(Concatenated Values, ID List) , where 'ID List' is the list with 'ID1', 'ID2',.... as members.

See the example here: ISFIRSTOCCURRENCE - Anaplan Technical Documentation

Regards,

Mandeep

CommunityMember126793

Thanks @mburdak

incorrectly picked the logic.. sorted. Thanks!

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…