Linking formula

Hi,

 

Please see details on the attachment.

 

Regards,

Best Answer

  • Misbah
    Answer ✓

    @Jsdeloria21 

     

    In your write up dimensionality of the modules are missing. However let me go ahead with one of the three assumptions

     

    Assumption 1 - Code is a list formatted line item in source and dimension in the target 

    Assumption 2 - Code is dimension in both the modules

    Assumption 3 - Code is a list formatted line item in both the modules ( Highly unlikely as you said it is without duplicates in target module)

     

    Below approach is based on Assumption 1

     

    Source Module : Dimension - Test List

     Line items - Code (List formatted)

                         Stat(List formatted)

     

    Misbah_0-1576476629227.png

    Misbah_1-1576476701821.png

     

    Target Module - Dimension - Codes

    Line item - Stat (List Formatted) and write the formula as shown below. It will pull all the first non blanks from the source module 

    IF ISNOTBLANK(Source Module.Stat[FIRSTNONBLANK: Source Module.'Code.']) THEN Source Module.Stat[FIRSTNONBLANK: Source Module.'Code.'] ELSE Stats.Unsold

     

    Misbah_2-1576476782066.png

     

    Assumption 2 - It is Straightforward/ Just refer the source in line item 1 and create another line item on top it and say if it is blank then unsold else Line item 1

    Assumption 3 - Although highly unlikely, you have to find a relationship between the dimensions of target module and source module and then use LOOKUP based on that

     

    Hope this helps

    Misbah

     

     

     

     

Answers

  • Hi Misbah,

     

    Appreciate that you take time in providing me some insights on my issue. I created a code so I can link it to the Target Module.

    Here is the scenario, the Source Module has the Source Mod List (transnational with duplicate entries) and the Target Module has a filtered version of the Source Mod List but without duplication.  See below.

     

    Jsdeloria21_0-1576480551146.png

    So the issue I have right now is that the code that I use in the Source Mod List does not accept duplication there I cannot capture all RU TEXT(Code) to link it to the Target Module. I also provided the formula that I just replace it with a different name since I cannot use the original list due to confidentiality. Feel free to correct my formulas.

     

    Regards,

     

  • Hi,

     

    I just want to correct the previous screenshot. Please see below

     

    Jsdeloria21_0-1576482896197.png

     

    Regards,