Export to Pipe delimited

[#1]

Hi Folks

I have a specific problem on exporting data that I'd like some help with.

I have a table with Dim1, Dim2, Dim3, Val1, Val2, Val3

I want to export to pipe delimited, however, where all of the Dim1, Dim2 & Dim3 values are the same, the values should be appended on the same line. Example

Dim1, Dim2, Dim3, Val1, Val2, Val3

A, B, C, 1, 2, 3

D, E, F, 5, 1, 7

A, B, C, 4, 7, 9

Exported to pipe delimited, the above data should produce a file as follows:

A|B|C|1|2|3|4|7|9

D|E|F|5|1|7

Hope this is clear.

Thanks for any help,

[vgutkovsky]

Use the concat() function and specify '|' as the separator. See the help file for more details.

Regards,