Parent - selected item from the parent list

Hello,

Is it possible to set up/select of the displayed parent in Anaplan?

I have a list of materials (A) whose parent is list (B).

List A - MATERIAL	List B - PARENT
Material A	1_2021
Material A	2_2021
Material A	4_2021

When I apply the formulas for Parent: PARENT(MATERIAL) then for Material A I get the result: 1_2021

I would like to get the last item in list B - 4_2021

Is it possible?

Accepted answers

All comments

Misbah

@Dominika_Dudzinska

See if this helps

I have created one Flat List for Materials - Which is a Non Numbered list

Misbah

Miz Logix

Dominika_Dudzinska

@Misbah Thank you for the solution.
The only problem is that sometimes the parent has plant in its name and then its name is XXX_1_2021 or XX_1_2021, so I have to use something more flexible here.

Misbah

@Dominika_Dudzinska

In that case create few more line items

Second Delimiter = FIND("_", Parent, Delimiter)

and then use MID function to extract 1,2,3 .....31.

Rest all will remain same

Misbah

Miz Logix

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…