Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

Translate the entire conversation x

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

AP_10343008
16-Pearl

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

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 */
});

ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

1 REPLY 1

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

Announcements


Top Tags