Register

Formula help requested

Sravan_Kumar
Community Boss

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
Misbah
Moderator

Re: Formula help requested

@Sravan_Kumar 

 

What is the ask?

Sravan_Kumar
Community Boss

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.

Akhtar.shahbaz
Community Boss

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

Sravan_Kumar
Community Boss

Re: Formula help requested

Thanks @Akhtar.shahbaz  for another way of approach.

I tried this way too.

Misbah
Moderator

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

 

 

 

 

 

 

Sravan_Kumar
Community Boss

Re: Formula help requested

Thanks @Misbah.

The Lookup function was really simpler and it worked well.