Highlighted
Community Boss

Linking formula

Hi,

 

Please see details on the attachment.

 

Regards,

3 REPLIES 3
Highlighted
Community Boss

Re: Linking formula

@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

 

 

 

 

Highlighted
Community Boss

,Re: Linking formula

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,

 

Highlighted
Community Boss

Re: ,Re: Linking formula

Hi,

 

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

 

Jsdeloria21_0-1576482896197.png

 

Regards,