Accessing Data in other module
I have 2 modules say A and B
Module A has id, name, key, value, key2_value
id name key value key2_value
1 x k1 v1
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
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?
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...
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]0
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 = text0
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.