How to apply group by functionality

[Raja_9513]

Hi Team,

I am facing an issue while showing only max date record with all record, please find the attached screenshots how actually the data is coming in front end. Kindly help me on this.

[rubenmarin]

Hi, can you post the full expression that you are using?

[AshutoshBhumkar]

Hello,

So, are you looking for a flag as 1 in front of the max date of employee_id ?

As @rubenmarin suggested please share the expression, maybe we can correct the same.

Thanks,

Ashutosh

[Raja_9513]

Hi All,

Actually i am not using any expression i need a suggestion on how to load the data in script level only max date for each employee. we have each employee have different max dates. I need to load only Max date record for each employee. please find the attached screenshot 

Input:-

OutPut:-

[rubenmarin · Accepted solution]

Hi, you can load your table with all employees and use an inner join to keep only the max date of each employee:

Inner Join (EmployeeTableName)
LOAD person_id
  Date(max(event_date)) as event_date
Resident EmployeeTableName
Group by person_id;