Mapping is returning unexpected value

[e_castilla]

Hey all, 

I am running into  bit of a mistery here. 

I have an excel file that reads the fields Cuente and RC (among others):

And then I have this mapping: 

From my understanding, the mapping if a key of a mapping, in this case Cuenta, is found several times, the value of the value field, in this case RC, should be the latest read value, so in this case, it should be 465, but for osme reason, it's 60. 

Can someone help me understand in what order are excel files read in QlikSense? Because I was always under the impression they were read in the same order as they are in the excel file. 

Furthermore, in an attempt to understand what's happening I extracted both the RecNo() and the RowNo() finding that: 

So at this point i dont know how to move forward. 

Cheers and thanks in advance. 

[SRA]

Hi, 

In case your mapping table contains several identical keys, applymap will choose the value of the first record loaded in the table.

In your excel, for Cuenta 7050000033 you will have RC 60 (first) and 465

ApplyMap will return 60.

If 60 is not the value you want to get, I would recommand to apply some selection rules during the load in order to have in the mapping table only one record per key with the value you want. If you need the last one from your excel file, you can load only the last one or sort the table by RowNo() desc (add rowno() during loading, and sort on this field).

Regards,

SRA

[SRA]

Hi,

Does my answer fits to your requirement ? If so, could you mark the answer as a "solution" ? (It will help others know that your request is fullfiled.) If not, please let us know and we will try to help you in a different way.

Thanks, SRA