Look up no working
Best Answer
-
Sorry…Module 2 formula i suggested is wrong…For timebeing u can import data from module 1 to module 2…That should work without any issue
V.Sai Bharadwaj
0
Answers
-
Formula would be Geo = Source Module.'Geo'[Lookup: Account Name, Lookup: Rank]
Regards,
1 -
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!!
2 -
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.
0 -
@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
0 -
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:
0 -
Thanks a lot.
0
