Filter in Load Script

AB01 — Tue, 16 Nov 2021 14:03:52 GMT

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.

Re: Filter in Load Script

MarcoWedel — Tue, 16 Nov 2021 20:41:21 GMT

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