You are not logged in.
Announcement
Unanswered posts
|
- Index
- » General questions
- » tAggregateRow
Post a reply
Topic review (newest first)
- Saya
- 2012-05-16 10:50:24
Hi Ben,
Thank you so much for your reply. We ar eusing Talend Open studio 4.0.1 and tUniqueRow component is not compatible with it. We also upgraded the version to 5.0.2, but still this component does not work here. Is there any alternative component from which the result can be achieved?
Regards,
Swathi
- phobucket
- 2012-05-15 21:11:42
Also, I forgot to mention, your error was because you specified the same output column name more than one time in the tAggregateRow
- phobucket
- 2012-05-15 21:10:16
Hi Swathi,
Install tUnpivotRow from the TalendExchange
http://www.talendforge.org/exchange/tos … hp?eid=148
Your flow will look like this:
tPostGresqlInput --> tUnpivotRow --> tAggregateRow --> tMap -->tPostGresqlOutput
tUnpivotRow will move your FS, ED, PP, Discount columns to separate rows, along with a label for the columntype
tAggregateRow will summarize the different amounts
tMap will be used to map the output of tAggregateRow to the corresponding db fields to be populated
Thanks,
Ben
- Saya
- 2012-05-15 16:51:11
Hi,
I have attached an excel file, please go through it. I have fields like order number, amount columns like FS amount (FS), ED amount (ED), PP amount (PP), Discount etc and description columns like FSD, EDD, PPD, DD etc in my table.
I want the output to be like this;
Surcharges Amount
FS 44.74
ED -147.19
PPD -67.74
Discount -422.67
Please see the screen shot of my job, Im getting error : Duplicate field AggOperationStruct_tAggregateRow_1
How can I solve this? Please suggest
Regards,
Swathi