Doesn't seem to be there, i think its 7.x screenshot. In which it might be buried somewhere or even not be there.PhilHibbs wrote:Nope, no "Preserve type" attribute...priyadarshikunal wrote:It can be found in sub property of 'Column for calculation'.
Selecting Max(date) column with multiple rows
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Last edited by priyadarshikunal on Wed Aug 11, 2010 10:29 am, edited 1 time in total.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
definately, its there in version 8.x, not quite sure about 7.x but if its not there (i think its not), one workaround can be converting it to julian date, before aggregator(or decimal as yyyymmdd/yyyymmddhh24miss ) to get the max and convert it back.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
I'm already aggregating the data on the key, then I found I needed the max date, so I just slipped it in.kumar_s wrote:Do you need an Aggregator? Why not just Sort the Data based on Code and Date and use Remove Duplicate to retain First. (Or last, based on sorting order)
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
It's there. Somewhere.priyadarshikunal wrote:definately, its there in version 8.x, not quite sure about 7.x but if its not there (i think its not), one workaround can be converting it to julian date, before aggregator(or decimal as yyyymmdd/yyyymmddhh24miss ) to get the max and convert it back.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers