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

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…