Reverse mapping

Options
vd_ghnst
vd_ghnst Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hi all

 

I have a source module with dimension list A and an output module with list B. To bridge this, I have a simple third module where the end-user can input the mapping between A & B. This works perfectly for a standard LOOKUP formula.

 

I was wondering if there's an easy way to reverse the mapping? I basically want another mapping module with list B as dimension and list A in the dropdown where list A is automatically populated based on the initial mapping.

 

vd_ghnst_0-1662735266849.png

 

Thanks!

Matthias

Tagged:

Comments

  • Misbah
    Misbah Member, ALL USERS, GroupMember, Partner, User Group Leader, Certified Model Builder Posts: 5

    @vd_ghnst 

     

    If there is a 1:1 mapping then you can say 

    Source Line item from Rev04[FIRSTNONBLANK: Rev04 Container Throughput]

     

    Hope that helps

    Misbah

    Miz Logix

Categories