Combining Data in two different Modules

neg177
neg177
edited December 2022 in Integrations and extensibility

Hi,

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

neg177_0-1670269334813.png

neg177_1-1670269377548.png

Source Module

neg177_2-1670269406131.pngneg177_3-1670269423454.png

Thank you

Tagged:

Best Answer

  • andrewtye
    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?

Categories