Combining Data in two different Modules



I have LI's from one Data Module that I need in another Data Module that doesn't share the same dimensions. The common mapping I would use would be BB Contract ID. What would be the best way to go about this?

Target Module



Source Module


Thank you

Best Answer

  • andrewtye
    edited December 2022 Answer ✓

    Hi @neg177 

    In the source model you'll need a line item that is BB Contract formatted (use finditem) and then use SUM in the target module to pull through the required values

    For the other types of line items will require an intermediate step as presumably there could be duplicates of the Contract ID and you'd want to be picking a particular item?