How can I get the minimum date in the aggregator?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 161
- Joined: Mon Mar 17, 2008 10:33 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Instead of using an aggregator stage to find a minimun date, you can use a "Remove Duplicates" sorting your date data with the "ascending" option (when you specify your partitioning). Finally, you have just to retain the first row (duplicate to retain : first). It works well with date type for each version.
Samuel
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
-
- Premium Member
- Posts: 288
- Joined: Tue May 27, 2008 3:42 am
- Location: Luxembourg
Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution.
On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine... No more warnings / aborts.
Basically what happens I guess is on choosing to preserve the datatype the output of the aggregator remains in iys source format.
On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine... No more warnings / aborts.
Basically what happens I guess is on choosing to preserve the datatype the output of the aggregator remains in iys source format.
Tony
BI Consultant - Datastage
BI Consultant - Datastage
-
- Premium Member
- Posts: 288
- Joined: Tue May 27, 2008 3:42 am
- Location: Luxembourg
Ha ha @ Craig
But before you and the Ray discipline me for the misdemeanor, in my defense I found 4 hits when I searched for the error message - No default type conversion from type "date" to type "dfloat".
Thought I'd thus update all 4 since in neither of them was the "preserve type" suggested as a possible solution...
But before you and the Ray discipline me for the misdemeanor, in my defense I found 4 hits when I searched for the error message - No default type conversion from type "date" to type "dfloat".
Thought I'd thus update all 4 since in neither of them was the "preserve type" suggested as a possible solution...
Tony
BI Consultant - Datastage
BI Consultant - Datastage