Accessing Data in other module

mohitveer_sandhu

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_num	id	name	key	value	key2_value
1	1	x	k1	v11
2	1	x	k2	v12	v12
3	1	x	k3	v13
4	2	y	k1	v21
5	2	y	k2	v22	v22
6	2	y	k3	v23

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

name	key2_value(requiredValue)
x	v12
y	v22

 

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?

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

@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

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

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.