Load table with latest logs values

[#1]

Hello,

In my data model, through load script, i need to generate a table with the latest logs values for each state linked to an ID. In data model we could have something like this:

How can I do this through load script?

Thanks!