Skip to main content
A
AP_1034300816-Pearl
16-Pearl
October 10, 2024
Solved

WriteCSVFile API withHeader: true changed The order of columns in generated CSV File

  • October 10, 2024
  • 1 reply
  • 729 views

While using the Resources["CSVParserFunctions"].WriteCSVFile API withHeader: true, The order of columns are changed in generated CSV File. How to maintain the same order of columns in CSV File.


Resources["CSVParserFunctions"].WriteCSVFile({
path: "/"+formattedDate+"/"+FolderName+"/"+FileName /* STRING */,
data: ExportData /* INFOTABLE */,
fileRepository: "WCCompareXA_Repository" /* THINGNAME */,
withHeader: true/* BOOLEAN */
});

Best answer by Rocko

The order should be determined by the ordinal of the column which you can set:

table.dataShape.fields["A"].ordinal = 3;
table.dataShape.fields["B"].ordinal = 2;
table.dataShape.fields["C"].ordinal = 1;

Check https://www.ptc.com/en/support/article/CS388066

1 reply

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
October 10, 2024

The order should be determined by the ordinal of the column which you can set:

table.dataShape.fields["A"].ordinal = 3;
table.dataShape.fields["B"].ordinal = 2;
table.dataShape.fields["C"].ordinal = 1;

Check https://www.ptc.com/en/support/article/CS388066

    Terms & ConditionsCookie settingsAccessibility statement