Flat list module to module with key made from the flat lists
I have a module dimensioned by 4 flat lists. A line item in this module creates a key using 3 of these flat lists.
I have another module dimensioned by the key and the 4th flat list. How can I map data from first module to the second module?
You need to use the lookup function.
Dimensions: Combined Key, 4th dimension
Breakdown Combined Key to it's 1st, 2nd and 3rd dimensions
Then do a lookup
Module 1.LineItemX[Lookup: 1stKey, Lookup: 2ndKey, Lookup: 3rdKey]0