Mapping Key

[karunaramteke]

Can anybody help me to get single key for Recon_No : 39638874-1

I want %RECEIPT_KEY as MD082001921098 and bank deposit amount 59639 in one row .

In chart it should show me %RECEIPT_KEY as MD082001921098 not 240820-59639 
I had used apply map and tried to solve it.
Can anybody help me to get single key for %RECEIPT_KEY MD082001921098

I had attached a qvw and excel for reference.

[karunaramteke]

Nobody can help me in this ??

[Kushal_Chawda]

@karunaramteke  Based on what logic you have applied you won't get single value.  What is the logic to get the single value?

[karunaramteke]

if we apply vlookup in excel we get the value

Please check Column C:3 in sheet1 (C column is Derived column.)

[Kushal_Chawda · Accepted solution]

@karunaramteke  see the attached

[karunaramteke]

@Kushal_Chawda  Thank you so much