Reverse mapping

vd_ghnst
vd_ghnst
in 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:

Answers

  • Misbah
    Misbah

    @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