How to Read back from a consolidated module

CommunityMember96641

Hi

Experts!

I have a module A using below dimensions - Sales Territory Quota Mapping list is a list with sequence numbers from P1 to P6000.

there are properties like Employee (using list of EmployeeAssignment) and Employee ID in this module.

And a module B like below, where I consolidated/summed the numbers by EmployeeAssignment (1 employee assignment might have been used in multiple Px list items in Module A)

Now Module B has a Status column, but we want to read back this status column at one employeeassignment to all its Px lines. How can I achieve that? Thanks a lot!

CommunityMember121571

Hi!
Did you try https://help.anaplan.com/f8baa402-606d-4764-a349-d8003fa383be-LOOKUP ?

pyrypeura

Hi,

@CommunityMember121571 is correct on advising to use lookup. If you have employee assignment and quota defined for PX items you can simply take. Module B.Value[LOOKUP: Employee Assignment, LOOKUP: Quota] from Model A.