Formula to get a Line Item formatted as a List based on a Trimmed data field

I am importing data with a field that has the names trimmed from a list. What formula can I use so that that rediscovered name corresponds to the name of the list in Anaplan?.

Let me try to show this example:

Data TXT File:

Crititcal Line Abrev Field:

Alloc

Credi

Direc

Fixed

Anaplan List:

Critical Line List:

Allocations

Credit and Income

Direct

Fixed

Indirect

What formula I need to use to create a Line Item formatted as a List [Critical Line List] based on Crititcal Line Abrev Field?.

Thanks a lot for any recommendation.

Accepted answers

rob_marshall

@gsmerilli

Use what you have in Data text file as the "codes" for the Anaplan list members. When importing into the line items, in the mapping area, you can specify the code and it will automatically find the corresponding list member.

Rob

All comments

rob_marshall

@gsmerilli

Rob

gsmerilli

Thanks Rob for your quick replay on this. In some way your answer solve my the issue so much appreciated. My concern still is if there is also another possible solution considering that modifying codes could be a manual job that could still impact our stored Actions and current automatic processes.. I was wondering on curiosity if I could still use a System Module or some other intermediate process that allow me to make the connection in between an abbreviated Data that is a LEFT 5 digits of an List Member. Thanks again for your help!!

rob_marshall

@gsmerilli

The best solution is to use codes, plain and simple. That way, you can name it whatever you want in Anaplan while still keeping the "audit" part in sync with your source system. Now, whether you have the code like in the text file or true numbers that you should have in a proper source system (which is best, but usually coming from a source file of csv you won't likely have), doesn't really make a difference. The bigger deal is to use codes, they will save you in the long run.

Hope this helps,

Rob

gsmerilli

Absolutely it helps!! Thanks!!

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…