Filter in Load Script

[AB01]

Hi,

I am trying to create a filter for students where I only call the most recent entry from a database.

This is the script I have at the moment;

LOAD uniqueID,
            max([Predicted End Date]) as [Expected Completion Date]
Resident learnerData
Group By uniqueID;

I would like to add an additional filter where the max([Expected Completion Date]) is only called if the course the learner is on is the same course.

Any help is much appreciated.

Thanks.

[MarcoWedel]

please post some test data and your expected result to clarify.
Thanks
Marco