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.