Pulling a column into an Import Module

SinduraDappili
SinduraDappili
in Modeling

I need to pull data from one module into another. Here's a breakdown of my setup:

Module1(G4 Metro Module): This module is dimensioned by G4 Metro list and includes a line item that maps 'Node classifications' to the G4 Metro items.
Module 2 (Import Module): This module is dimensioned by a numbered list (UID) and has a line item for the country (Find Country) that has G3 countries.

G4 Metro rolls up to G3 country list.

I need to pull the 'Node classifications' column from the G4 Metro module into the Import module. I could not use parent function as it does not apply in this context.

What’s the best way to pull Node classifications into the numbered listed Import module?

πŸ˜€

Best Answer

  • Prajjwal88
    Prajjwal88
    Answer βœ“

    Hi @ISha ,

    To pull the 'Node classifications' data from the G4 Metro Module into your Import Module (dimensioned by the UID numbered list), if you want to pull data using an import action then based on current scenario which you mentioned will need a UID list formatted line item in the source module (G4 metro module) for mapping and I don't think you have that.

    Although You can retrieve the 'Node classifications' values using a LOOKUP based on the G3 Country line item. Since the G4 Metro list rolls up to the G3 Country list, and the 'Node classifications' are mapped at the G4 Metro level, it's important to handle scenarios where multiple Metro items exist within a single country.
    To address this, you'll need to set an appropriate summary method (such as 'First non-blank' or 'Last non-blank') on the 'Node classifications' line item in the source module. This ensures that when you perform the LOOKUP in the target module, the correct aggregated value is retrieved based on the country mapping. please refer to example screenshots,

    image.png

    image.png








    Hope this helps.

Answers

Categories