CSVEXPORT Duplicating Lines

[Earl.Harris]

When using CSVEXPORT to create an Excel file the pipe items are being duplicated.

Item No	Qty	Name	Description	Specification	Connector
3	127.659 (inch)	Pipe-A53-CS-(B)-SCH80-BLK(PE)	20''		GRC_Tube_Plain End
3	127.659 (inch)	Pipe-A53-CS-(B)-SCH80-BLK(PE)	20''		GRC_Tube_Plain End

I am filtering out all the other parts( by CID) to leave just the pipe. I only need the one line so the quantity fields will total up correctly.  

[andy.robins]

The reason you are getting 2 lines is because you have the connector name in the export so you get one line for each.

To rectify you can either select "Merge Rows Together" on the Order tab but that will only work if the connectors are the same at both ends, OR you can set "Display Data for Index" and specify 1 in the Contents tab so it only shows the connector at end 1.