Hi,
Is there any issue to find maximum of date.
mine is simple flow. input has data with date type feild. i just need find the max of the date based up on a grouping col. Iam getting the follwing error
Aggregator_1: Error when checking operator: When binding input interface field "doj" to field "doj": No default type conversion from type "date" to type "dfloat"
Here "doj" id the name of the date field. it seems it is implictly converting from date to dfloat. i just grouped based on a column and found Maximum Value Output Column of this "doj" and nothing else. Output is also in date format.
Should i have to do anything more than this for date type or it happens for all?!?!?!?.......
Hi,
yes we tried every thing else, Iconv and Oconv works.
But we faced sluggish response of server due to Basic Transformer usage. Resulted in restrating server
Tried with StringToDecimal and then back to date. But unfortunately i faced a error which carries a native datatype of decimal all along to way.
We also had a thread reg this issue in this forum.
Atlast Tring with varchar oriented conversion, mmmm... WORKING. Feeling bad to carry two transformer on both side of Aggregator
when i tried with char or varchar oriented method, i faced an issue which return only the year part.
But the way in which senthil proceeded, no probs........
works good
One approach is to Convert your date in the Integer format means if yor date is "yyyy-mm-dd" then convert it into "yyyymmdd" which is the integer and then use the max/min function. You can not aggregate on Date column as Aggregator stage converts into default dfloat before doing any aggregation.
Hi,
may i know how to convert to integer, is it through datetostring..... or any methond available.........
regards
kumar
Hi,
One approach is to Convert your date in the Integer format means if yor date is "yyyy-mm-dd" then convert it into "yyyymmdd" which is the integer and then use the max/min function. You can not aggregate on Date column as Aggregator stage converts into default dfloat before doing any aggregation.
Things that are "promotable", for example int8 to int16 or int32, can convert implicitly in parallel jobs. Otherwise the conversion must be performed explicitly. There is a table explaining this in the Parallel Job Developer's Guide, from memory in the chapter on the Modify stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.