Using LOOKUP on multiple properties in a Numbered List

Walker32
Walker32
in Modeling

Hi - Wondering what is the best/practical process here. I have a Numbered list (#Job Profile) with "comp code" and "comp location" as properties (Attached for reference).

I have a module has the Job Profile Code (Job code = comp code) and Connect Comp Location, the data/line item by itself is not unique but the paring should equal a member on the #Job Profile list.

Can I use the values in the module for this line item to Lookup on the numbered list and retrieve the code of the member in the list?

What is the ideal way to achieve this?

module.png
List.png

Tagged:

Answers

  • Venki9902
    Venki9902

    Hi @Walker32 ,

    Does your module has the same mentioned member list as dimension?

    if so you can refer these lineitems in formula bar your list properties.

    Hope this helps :).

    Regards,
    Venkatesh

  • Walker32
    Walker32

    hi @Venki9902 - the module is a flat mapping module. I don't want the reference the module in the list but want to reference the corresponding list member in the mapping module using the 2 line item values found in the mapping module.

  • Venki9902
    Venki9902

    Hi @Walker32 ,


    I think your below mentioned statements would be a better approach.


    Use the values in the module for this line item to Lookup on the numbered list and retrieve the code of the member in the list.


    regards,

    Venkatesh

Categories