Accessing Data in other module

Highlighted
Occasional Contributor

Accessing Data in other module

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?

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Accessing Data in other module

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

Highlighted
Super Contributor

Re: Accessing Data in other module

@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]

 

 

Highlighted
Occasional Contributor

Re: Accessing Data in other module

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

 

Highlighted
Super Contributor

Re: Accessing Data in other module

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.