Grouping Data in a dataport

srij

HI All
How to group the datas (sum it) in a table based on customer No. and to export out using dataport..
For eg

Cust1 - 500
Cust2-300
Cust1-400
Cust3-600
Cust2-200

So in the dataport i should port out values like Cust 1 - 900 (500+400) , cust 2- 500 (300+200), Cust3-600

Thanks

vijay_g

You can not group data in dataport either do import or export.

srij

Yes, i need to export to an excel file using dataport
How to group the datas through coding from a table like this and export to excel/csv?
Appreciate all advices

mohana_cse06

vijay_g wrote:

You can not group data in dataport either do import or export.

this is not a question...this is an answer..

srij

How to group the datas through coding from a table and export to excel/csv? Requirement as below


For eg

Cust1 - 500
Cust2-300
Cust1-400
Cust3-600
Cust2-200

So in the exported file i need values like Cust 1 - 900 (500+400) , cust 2- 500 (300+200), Cust3-600

mohana_cse06

You can create a report and group by (GroupTotalFields) "Custome No."
Export the values to excel using excel buffer

ssingla

Not exactly you require but can be used to fulfill your requirement. Use Temp Table to insert values (grouped) and then export temp table.