How can I get min value of date from aggregator stage? I am getting the below warnings.
Can you please help me?
Aggregator_1: Error when checking operator: When binding input interface field "DATE1" to field "DATE1": No default type conversion from type "timestamp" to type "dfloat".
Error when checking operator: When binding input interface field "DATE2" to field "DATE2": No default type conversion from type "timestamp" to type "dfloat".
error on aggregator
Moderators: chulett, rschirm, roy
You can get a MIN or MAX of only a number column in Aggregator stage in PX.... 
The easist way would be to use a sort->Remove Duplicate stages after adding a constant value column and sorting on the date-field you want the MAX for.
Another way of doing it would be to derive a new integer for the timestamp columns by comparing it to a low timestamp like 01-01-1900 00:00:00 and get the MAX of the integer to get the record with max date...
The easist way would be to use a sort->Remove Duplicate stages after adding a constant value column and sorting on the date-field you want the MAX for.
Another way of doing it would be to derive a new integer for the timestamp columns by comparing it to a low timestamp like 01-01-1900 00:00:00 and get the MAX of the integer to get the record with max date...
-
vishnuhpatel
- Participant
- Posts: 3
- Joined: Mon Nov 20, 2006 9:34 am
- Location: mumbai
Re: error on aggregator
reddy12 wrote:How can I get min value of date from aggregator stage? I am getting the below warnings.
Can you please help me?
Aggregator_1: Error when checking operator: When binding input interface field "DATE1" to field "DATE1": No default type conversion from type "timestamp" to type "dfloat".
Error when checking operator: When binding input interface field "DATE2" to field "DATE2": No default type conversion from type "timestamp" to type "dfloat".
User sort stage on Date field and then use header/tailer stage to get min/max date.
On more way is to convert the date to Julien date in a Transformer and then pass it to Aggregator stage. Do MIN and MAX and then convert Julien date back to date format you want it in.Jai_sahaj wrote:You can get a MIN or MAX of only a number column in Aggregator stage in PX....
The easist way would be to use a sort->Remove Duplicate stages after adding a constant value column and sorting on the date-field you want the MAX for.
Another way of doing it would be to derive a new integer for the timestamp columns by comparing it to a low timestamp like 01-01-1900 00:00:00 and get the MAX of the integer to get the record with max date...
Hope it helps...
Assume everything I say or do is positive