Accessing Data in other module

mohitveer_sandhu
mohitveer_sandhu
in Modeling

Hi,

 

I have 2 modules say A and B

Module A has id, name, key, value, key2_value

For example:

id     name         key           value            key2_value

1         x              k1              v1

row_numidnamekeyvaluekey2_value

1

1

x

k1

v11 
21xk2v12v12
31xk3v13 
42y

k1

v21 
52yk2v22v22
62yk3v23 

The formula for key2_value is IF key = "k2" THEN value ELSE BLANK

 

Module B has name as rows and line item as key2_value

namekey2_value(requiredValue)
xv12
yv22

 

I want the key2_value(requiredValue) in the line-item that will be mapped to module A. How can I achieve this as using simple lookup returns only blank?

Tagged:

Answers

  • anirudh
    anirudh

    Assuming the column 'name' is a list, try this formula in Module B:

    Module A.'key2_value'[TEXTLIST: Module A.name]
    That should work

    But generally speaking, using textlist is not the best idea...

    Regards,
    Anirudh

  • ChrisAHeathcote
    ChrisAHeathcote

    @mohitveer_sandhu 

    From your query I will assume that module A contains id as its dimension and module B name.

     

    If this is the case you need to create a mapping module dimensioned by name so that you can map each list item to a correct id.

     

    Once you have this the formula would be =module A.key2_value[lookup:Name mapping.id]

     

     

  • mohitveer_sandhu
    mohitveer_sandhu

    module A has row_num as dimension and all other are line items formatted as
    Name = List

    id = text (code in name list)

    key, value = text

     

  • ChrisAHeathcote
    ChrisAHeathcote
    Therefore, you need to create a mapping from module A row_num to the list which forms the dimension of module B.
    Reference module A from module B and lookup this mapping to pull the data across.
    Without a dimension in module B and the mapping there is no way to establish the relationship between modules and therefore the mapping required.

Categories