Reference of numbered list via display name
I have a numbered list where code property is an index like 1,2,3,…… which i cannot use to pull the properties from the list.
In this list i have 3 other columns p1, p2, p3 and in another module i have a line item which has similar values like p3.
In this same module i am trying to get the values from p2 & p1 in another line items(mP1, mP2) something like - mP2=numberedList.p2[lookup : 'mP3'] where mP3 is line item in module with similar values like p3 in list.
for FindItem i will need to use the value for CODE in arguements which is not going to help in my scenario.
I have also created a module for this particular list dimensioned by the list.
Answers
-
@JAbhi : when you have these situations always look at source and target dimensionality. In your case, you need to apply an aggregation method as LOOKUP cannot be used . see below more details
The source module has dimensionality the numbered list.
The target module has the dimensionality P3 (I presumed that similar to P3 means the list P3).
The only link between Source and Target dimensionality is the line-item mP3 (which needs to be formatted as List P3).
The only way to reference from the numbered list to target P3 module is to apply an aggregation method.
As P1 and P2 are also lists (or text) .. the only aggregation methods that can be applied in this case is FIRSTNONBLANK or LASTNONBLANK …
so the formula in the target line-item mP2 (module with P3 list) can be something like mP2=numberedList.p2[FIRSTNONBLANK : 'mP3']
However, be aware this will return in the target module with P3 list, the first or the last occurrence of a P3 value present in the numbered list. This needs to be considered if in the numered lists exists multiple rows with the same value of P3.
If P1, P2 would be numeric line-items in numered list module… the aggergation method can be SUM, MAX, etc…
I hope it helps,
Alex
0
