Formula help requested

Sravan_Kumar
Sravan_Kumar
in Modeling

Hi Friends,

I am struck with a query.

Need your assistance to proceed forward.

 

Sravan_Kumar_0-1586861133955.png

 

 

Tagged:

Best Answers

  • Misbah
    Misbah
    Answer ✓

    @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

     

  • Akhtar.shahbaz
    Akhtar.shahbaz
    Answer ✓

    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

Answers

Categories