LastrowinGroup function in datastage

[mvrkreddy]

can i use 3 LastrowinGroup functions with different columns in one transform stage ????

[chulett]

Not quite sure what you mean but since you can only have one group there, then yes but only if the 'different' columns are a subset of the grouping columns on the leading edge.

Or at least that what I'm thinking. Would have been easier just to say no.

[ray.wurlod]

Have you tried it?

I can't envisage how you would manage the three separate grouping (sorting) requirements.

[qt_ky]

See also: viewtopic.php?t=153322

[prahul4all]

LastRowInGroup Function can be used more than once,This case occurs when we want to use LastRowInGroup function for more than one field.But Before using this function the fields used in this function should be sorted.

See the below link for better understanding
http://www.idatastage.com/lastrowingrou ... datastage/