Select Max in Load Statement

[kkorynta]

Hello,

I have a list that includes revision numbers. I'd like to 'roll up' the data in the load statement so only the current versions are selected.

I thought it would be something along the lines of

NoConcatenate Load [Special Key], max([Revision No]) as [Max Revision No], NPI
Resident NPI
Group By [Special Key], NPI;

But this doesn't seem to be the case.

Any idea where I'm going wrong?

Thanks!

[kkorynta · Accepted solution]

Nevermind,

Looks like one of the other current posts had a very similar problem.

Looks like all I was missing was

Inner Join

Load [Special Key], max([Revision No]) as [Max Revision No], NPI
Resident NPI
Group By [Special Key], NPI;