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

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

Best Answer

  • TonyViGrand
    TonyViGrand
    Answer ✓

    Hi @jbaudino1 

     

    Try using either firstnonblank or lastnonblank instead of lookup.

     

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

     

    Hope this helps.

     

    Regards,

    Tony

Answers

Categories