DSXchange

Hi,

I'am having 2 inputs in Aggreagator Stage
i. PERSON_K (Integer)
ii. SRC_EFF_Y (Date)

Sort method has kept to Hash
Partitioning set to Auto.
Column is grouped by 'Person_K' & calculation is done for SRC_EFF_Y.
i.,e Max. value output column
I have changed the column name at the o/p of aggregator stage to the other than what I have in i/p i.,e SRC_EFF_Y_TEST

But still getting Fatal error as
Agg: Error when checking operator: When binding input interface field "SRC_EFF_Y" to field "SRC_EFF_Y": No default type conversion from type "date" to type "dfloat".

Thanks

See if thispost helps.

All Aggregator stage calculation columns generate data type dfloat.

Try converting the date to Julian and getting the max of that, then converting back to any desired date format.

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.