Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.