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.

    Module 2:

    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]