DMXzone Data Exporter Support Product Page
Concatenate fields before exporting
Asked 31 May 2017 13:27:12
31 May 2017 13:27:12 David Woolley posted:
I need to concatenate 3 fields before exporting to CSV
A catalogue number comprises 3 fields from a query
For example: field1-field2-field3
This must export to ONE column in Excel (other fields are exported as well)
Is there a workaround for this in Server Data Formatter?
Or should I create a view in phpmyadmin like so?:
SELECT CONCAT(field1, "-",field2, "-", field3) AS catalogue_no
Replied 31 May 2017 14:05:59
31 May 2017 14:05:59 Teodor Kuduschiev replied:
Unfortunately there is no such an option available for the data exporter available. The best way is to create a view.
Reply to this topic