topic Re: tAggregateRow - sum double variables possible? in Talend Studio

tAggregateRow - sum double variables possible?

Anonymous — Mon, 05 Aug 2013 09:48:05 GMT

Hello, quick question to which I couldn't find the answer elsewhere.
Will tAggregateRow's sum function work if I feed it with double values or does it only work with ints?
Thanks in advance

Re: tAggregateRow - sum double variables possible?

Anonymous — Mon, 05 Aug 2013 10:15:48 GMT

Hi,
The tAggregateRow support for double data type.
To make it more clear, I have made a demo job.
Input:
1.33;4
2.24;4
See my screenshots for details
Best regards
Sabrina

Re: tAggregateRow - sum double variables possible?

Anonymous — Mon, 05 Aug 2013 10:24:50 GMT

Okay perfect. Thanks Sabrina

Re: tAggregateRow - sum double variables possible?

Anonymous — Mon, 05 Aug 2013 10:36:46 GMT

Hi,
Feel free post your issue on forum.
Best regards
Sabrina

Re: tAggregateRow - sum double variables possible?

Anonymous — Fri, 20 Sep 2013 22:54:31 GMT

Hi,
I have to calculate average for a field in which it is necessary to ignore null values, I am using the component tAggregateRow and the input is from tMap the field is a String, but i get this message
Warning:the operation 'sum' for the output column 'MV' can't be processed because of incompatible input and/or output types

i tried to change to double but i think this will return unwanted caculations because it will consider 0 where there is actually no data, right?
how can i get a way of ignoring nulls?

Re: tAggregateRow - sum double variables possible?

Anonymous — Sat, 21 Sep 2013 04:05:18 GMT

Hi
Use a tFilterRow to filter the rows that are empty or null value before tAggregateRow, and convert the data type from string to a numeric type for the oeration 'sum'.
Shong

Re: tAggregateRow - sum double variables possible?

Anonymous — Fri, 07 Dec 2018 07:01:02 GMT

Hi,

I have negative values in my data and i want to sum up using aggregate row. but the results are as follows.

input:

-10

expected output:

actual output:

can someone help me?

Re: tAggregateRow - sum double variables possible?

manodwhb — Fri, 07 Dec 2018 07:12:41 GMT

@keerthi-gurudu,check the below screenshot.

Re: tAggregateRow - sum double variables possible?

Anonymous — Fri, 07 Dec 2018 07:26:43 GMT

@manodwhb

my job looks as below. I have my input coming from the file using tmap to get specific columns. this case sum is not working as expected?

can u help me to resolve this issue?

Re: tAggregateRow - sum double variables possible?

manodwhb — Fri, 07 Dec 2018 07:30:05 GMT

@keerthi-gurudu,in the invoiceout section,how many fields are you passing to taggregaterow?

Re: tAggregateRow - sum double variables possible?

Anonymous — Fri, 07 Dec 2018 07:37:00 GMT

@manodwhb

I am passing 3 fields

Invoice output:

Aggregate row component screenshot:

Re: tAggregateRow - sum double variables possible?

Anonymous — Fri, 07 Dec 2018 07:37:32 GMT

@manodwhb

I am passing 3 fields

Invoice output:

Aggregate row component screenshot:

Re: tAggregateRow - sum double variables possible?

manodwhb — Fri, 07 Dec 2018 08:08:55 GMT

@keerthi-gurudu,based on the group by columns,your out put is varying ,please check.