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

jbaudino1
Occasional Contributor

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

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
TonyViGrand
Contributor

Hi @jbaudino1 

 

Try using either firstnonblank or lastnonblank instead of lookup.

 

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

 

Hope this helps.

 

Regards,

Tony

View solution in original post

2 REPLIES 2
TonyViGrand
Contributor

Hi @jbaudino1 

 

Try using either firstnonblank or lastnonblank instead of lookup.

 

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

 

Hope this helps.

 

Regards,

Tony

jbaudino1
Occasional Contributor

Hi @TonyViGrand  yes, it worked!

Thanks appreciate your help !