Look up no working

Hi Community. I have the following couple of models. In green you'll find the dimensions and in yellow the line items. I need based on the Rank from module 1, to pull the geo into module 2.

Thanks.

Best Answer

Answers

  • Formula would be Geo = Source Module.'Geo'[Lookup: Account Name, Lookup: Rank]

    Regards,

  • Hi @sansergi

    Umang's formula is the one you need to apply. Make sure that Rank is list formatted line item, if not then create a list with (1-3) numbers in it. And use that in line item, then use lookup

    Cheers!!

  • Thank you guys. So far, the first lookup is working (Lookup: Account Name) but when I try to look up for Rank, I get: "Format of mapping used for lookup doesn't match any dimension of the source".

    Rank is a list formatted line item in both modules. Is there anything I am missing? Thanks a lot in advance.

  • @sansergi In order to apply formula what Umang suggested… First you need to create a Intermediate module whose dimensions are Rank, Account and line item will be Geo [Geo = Table1.Geo(lookup:Rank)]

    From this intermediate module u can pull Geo to your Opportunities module based on logic suggested by Umang

    V.Sai Bharadwaj

    Connect on LinkedIn

  • Thanks V.Sai. But still no working. "Format of mapping used for lookup doesn't match any dimension of the source". Let me bring the full picture of what I have so far:

  • Thanks a lot.