DMXzone Data Exporter Support Product Page


Concatenate fields before exporting

Asked 31 May 2017 13:27:12
has this question
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
etc, etc


Replied 31 May 2017 14:05:59
31 May 2017 14:05:59 Teodor Kuduschiev replied:
Hi David,
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