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
Group By [Special Key], NPI;
But this doesn't seem to be the case.
Any idea where I'm going wrong?