You are not logged in.
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;
Please see the screen shot of my job, Im getting error : Duplicate field AggOperationStruct_tAggregateRow_1
How can I solve this? Please suggest
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
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?