Accessing Data in other module

mohitveer_sandhu
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
anirudh
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

ChrisHeathcote
Community Boss

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]

 

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
mohitveer_sandhu
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

 

ChrisHeathcote
Community Boss

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.
Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA