DSXchange

tried the same hashed file as input to the transformer and of course it worked and I guess this means that it is the data format.

//Mattias

Found something not sure if it means anything. When my both feeds goes into the transformer to get summed, the lines that are 0 are not 0.0000 but only 0. Is this right? Even if I have put them to decimal, scale 4. thanks a lot... [quote="mattias.klint"]Nope, does not work. What is the bes...

Nope, does not work. What is the best way to change data types, I do it in the hasded files?


Test it buddy. It doesnt work due to improper datatypes as the error message states.
Do this, initialize the stage variable as 0.0000
See if that helps.[/quote]

I use Char in all the job, but the aggregator I have Decimal, therefore the two hashed files arround the aggregator also decimal. The decimal is length 100(just like all char) and the scale is 4. The hashed files around the aggregator is input(before) and output(after) char with length 100. After th...

Found out something more. If I put a FMT(FIELD,"R0") in the FEED that comes from my aggregator before my transformer the Stage variable adding the two fields (FEED_1.FIELD1 + FEED_2.FIEDL1) works fine. Guess my question is getting more and more messy, hope you understand. /Mattias who want...

Thats what I tried to do, add two columns from diffrent feeds, but I have to do it in a StageVariable, and there I get this error: DataStage Job 123 Phantom 22318 Program "JOB.1371933176.DT.1426135363.TRANS1": Line 329, Improper data type. Attempting to Cleanup after ABORT raised in stage ...

Or maybe I should put it like this, does anyone have any comments on summing fields with an aggregator?

;-)

Hi, I have an aggregator that sums a field. In the hashed file before the aggregator the field beeing summed is Char. In the aggregtor it is decimal with 4 decimals. This seems to work fine. The problems come when I after this has an transformer where I have two inputs, I match some fields, this wor...