CSV Export - Issue with Column Names

[cheshirealan]

I have a list which joins a table to itself

All items in the list view are from the first table.

I select which fields I want in the CSV from the first table.

Data is exported correctly but headings are replicated:

Column1,Column1_1, Column 2, Column2_1,etc?

Any advice or is it a bug.

 

[cheesegrits]

Are you selecting columns from the "join to itself" to export?

-- hugh

 

[cheshirealan]

I join table A to table B, all the columns for the export are from table A.

Table A and Table B are the same table.

Thanks

 

[cheesegrits]

I'm still not sure what the issue is.

Are you using labels, or element names as you headings?

As the join is to the same table, I would expect headings to be duplicated for the joined data, if using element names as headers.

-- hugh

 

[cheshirealan]

I am using element names but why should it replicate the column names when all exported columns are from one instance of the table?

 

[cheesegrits]

Probably because the export code uses element names to figure out whether it's supposed to be exporting given element names, and because they are the same ...

No doubt we didn't anticipate exporting data with a list joined to itself.

-- hugh

 

[cheshirealan]

I wouldnt normally join a table to itself but the data is from a commercial extension so I have no control over the datbase schema.

 

[cheesegrits]

Nothing I can really do, you'll just have to manually remove the unwanted columns after export.

-- hugh

 

[cheshirealan]

Thanks Hugh