Get MAX(index) FROM table [tMysqlRow]

[Anonymous]

Hi all,
I'm trying to get the maximum value of a column which contains INT values.
Therefore, I use a tMysqlRow with the following query:

"SELECT MAX(id_partner) FROM BI_DWH_dimension_partner"

Then I try to link this tMysqlRow with a tMap, but during the execution of the job we can see that the value of the row loaded is null.
What am I doing wrong here?
Thank you for your advice

[Anonymous]

Yes indeed, I am sorry, I forgot to tell you that I changed the Lookup Model as "Reload at each row" (screenshot below).
But I am still facing the same error.
The third screenshot is just to confirm that I have data in the table so I am not suppose to get any java NullPointerException.
Thank you for following me up on this issue.
  

[Anonymous]

Hi @jlolling,
Any update on my issue ?
I looked into it, but I don't understand why this error is raised.
I added to my previous post 3 other screenshot for each tMysqlInput.
Maybe it will helps to understand that issue.
Thx.