Fetching values from one module into another

Options
AvnishGoel
AvnishGoel
in Modeling

I have two modules PROD and TRANS

TRANS module is having the dimension of TRANS and looks like this. Two line items PROD ID (List as Product) and boolean (checkbox).

Source

Product ID

Boolean Source

TRAN001

PROD001

TRUE

TRAN002

FALSE

TRAN003

PROD 003

TRUE

PROD module looks like this

Dimension of Product and line items as Source Boolean )Boolean) and Product (List Product)

Source Boolean

Source Product

PROD001

PROD002

PROD003

End Result should be

Source Boolean

Source Product

PROD001

TRUE

PROD001

PROD002

FALSE

PROD003

TRUE

PROD003

My problem statement is - there is no mapping module of having TRANSID AND PROD ID

I ran into the issues like "Automatic Sum" and "Dimension Mismatch"

Any pointes will be helpful.

I tried simple lookup and summary method like LASTNONBLANK etc. which did not work

Tagged:

Answers

  • cbrookes
    cbrookes
    Options

    Here's how I think you could tackle this:

    Source Product Formula in End Result module = TRANS.Product ID[LASTNONBLANK: TRANS.Product ID]

    Source Boolean Formula in End Result module = ISNOTBLANK(Source Product)

  • Dikshant
    Dikshant
    Options

    @cbrookes, formulas looks correct but the Source Boolean is dependent on Boolean Source from TRANS module. In that case ANY function would be a better option for Source Boolean in scenarios where for a TRANS there is a Product present but Boolean Source is FALSE. End result Source Boolean must show FALSE even if the Product is present.

    Source Boolean in End Result module:

    TRANS.Boolean Source[ANY: TRANS.Product ID]

  • cbrookes
    cbrookes
    Options

    @Dikshant I agree that your solution is better! Thanks for sharing.

    My solution assumed the Source Boolean will always be false if the product is NULL. Even if my assumption is correct, your solution is better from a performance standpoint because my solution uses daisy chaining.

  • Vamsi_Kaki
    Vamsi_Kaki
    Options

    Hello,

    What if, in the source module Same Product appeared multiple teams for different Trans and Boolean data is not depend on present of Product data. In that case, How can we pull Boolean data from source module

Categories