Formula help requested

Highlighted
Super Contributor

Formula help requested

Hi Friends,

I am struck with a query.

Need your assistance to proceed forward.

 

Sravan_Kumar_0-1586861133955.png

 

 

6 REPLIES 6
Highlighted
Master Anaplanner/Community Boss

Re: Formula help requested

@Sravan_Kumar 

 

What is the ask?

Highlighted
Super Contributor

Re: Formula help requested

Hi @Misbah.

I want the Edited name (has to be created) and not the Old name (already exists).

Please suggest me a way.

Highlighted
Super Contributor

Re: Formula help requested

Hi @Sravan_Kumar 

 

If you want to replace old name with new name then create one import action to update the name of the list based on existing code.

Old Existing List

 

Screenshot_286.png

 

Create one module with fruit dimension and add two line line :

Screenshot_288.png

Create an import action:

Screenshot_289.png

Screenshot_290.png

 

Hope this helps!

Thanks

Akhtar

Highlighted
Super Contributor

Re: Formula help requested

Thanks @Akhtar.shahbaz  for another way of approach.

I tried this way too.

Highlighted
Master Anaplanner/Community Boss

Re: Formula help requested

@Sravan_Kumar 

 

What is the logic here?

 

This can be achieved by Writing IF ELSE statements but I will definitely not go that way. Instead It can be built as a mapping module and you maintain the mappings and then use LOOKUP. 

 

Mapping Module - Fruits as a dimension

Create a line item "New Name" - List Formatted on Fruits

 

Target Module 

Line item = Mapping Module.New Name[LOOKUP: Old Name] 

 

Hope that helps

Misbah

 

 

 

 

 

 

Highlighted
Super Contributor

Re: Formula help requested

Thanks @Misbah.

The Lookup function was really simpler and it worked well.