cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Columns order problem Data Export Extension

Highlighted
Newbie

Columns order problem Data Export Extension

Hi there,

I use Data Export Extension with for excel and pdf exports but i can't order columns. I had found solution in here​ then i tried CSV Parser Functions. Yes, it worked just for newReportInfoTable but result is like attachment;

How can i order columns when exporting?

..

..

..

..

var params = {

    inputInfoTable: reportInfoTable,

    orderedFieldList: 'Period,AverageMilSpeed,AverageEntryCoilDiameter,AverageExitCoilDiameter,AverageExitWidth'

};

result: INFOTABLE

var newReportInfoTable = Resources["CSVParserFunctions"].GetOrderedFieldOutput(params);

var params = {

    infotable: newReportInfoTable

};

var result = me.ExportInfotableAsExcel(params);



Thanks

2 REPLIES 2
Highlighted

Re: Columns order problem Data Export Extension

Sorry, what is the problem with the attachment? I am not sure I understand.

Highlighted

Re: Columns order problem Data Export Extension

Hi Gokhan Cakiroglu​, So, the order is not correct in CSV as compared to the Service. Did you get any error in the logs?

Try passing the orderdedFieldList as an array if it helps.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!