Load Value by max Date

[etrotter]

Hello,

I am trying to load Pay rate by max modification date, but it doesn't seem to be working correctly:

NoConcatenate

Compensation:

LOAD AgentID,

     Maxstring(ModificationDate) as ModificationDate,

     Max(PayRate) as PayRate

Resident Compensation_Temp

Group by AgentID;

I want one payrate per AgentID, here is the current output:

Let me know if you can help!

[Digvijay_Singh]

Script is showing group By field AgentID but output is showing dimension as W_CODE, can you clarify. Also for date not sure why you have used MaxString instead of Max?If possible please share sample app to unnderstand it further.