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