Getting Error "format of mapping used for lookup doenst match any dimension of the source" no clue

Options
jbaudino1
jbaudino1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

 

I have a source module dimensioned by tmpSalesTerritory list, that is a numbered list

jbaudino1_1-1644679424774.png

 

Need to get “final_segment_country” and put it in this module below on yellow marked

jbaudino1_2-1644679457231.png

The problem is when I lookup the value from property module I received the msg below…

jbaudino1_3-1644679475262.png

 

Can you help me to understand what is happening?

Since I getting the same dimension and lookup dimension needed to destination module

 

Tagged:

Comments

  • TonyViGrand
    TonyViGrand Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    Hi @jbaudino1 

     

    Try using either firstnonblank or lastnonblank instead of lookup.

     

    Eg; Input03Module.finalsegmentcountry[firstnonblank:D33Salesproperties.Rep]

     

    Hope this helps.

     

    Regards,

    Tony

  • jbaudino1
    jbaudino1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Hi @TonyViGrand  yes, it worked!

    Thanks appreciate your help !

Categories