Want to get only maximum value from multiple row data

[rwaikar]

Hi,

I want to get only maximum session ID value from the multiple row data for same user and same exam.

Example and Current data like:

Exam User Session ID	User Email	Exam Name
1053	william.kennedy@eccellent.com	Windchill Associate Certification Exam
1120	william.kennedy@eccellent.com	Windchill Associate Certification Exam
1132	william.kennedy@eccellent.com	Windchill Associate Certification Exam
1304	william.kennedy@eccellent.com	Windchill Associate Certification Exam
1316	william.kennedy@eccellent.com	Windchill Associate Certification Exam
1606	whrn87@motorolasolutions.com	Creo Associate Certification Exam
1608	whrn87@motorolasolutions.com	Creo Associate Certification Exam

Desired Result:

Exam User Session ID

User Email

Exam Name

1316

william.kennedy@eccellent.com

Windchill Associate Certification Exam

1608

whrn87@motorolasolutions.com

Creo Associate Certification Exam

Thank you in advance.

[Gabbar · Accepted solution]

In load Editor:-

Table:-
Load * from Source;

Table2:-
Load Max(Exam User Session ID) as Exam User Session ID, "User Email", "Exam Name" resident Table
Group by "User Email", "Exam Name";

Drop Table Table;

In Set Analysis:-
aggr(Max(Exam User Session ID),"User Email", "Exam Name")