mapping_columns_to_export
Specify a new column sequence when exporting.
Call:
cancel mapping and the next export:
ts_table(iTable,"mapping_columns_to_export");
set mapping:
ts_table(iTable,"mapping_columns_to_export",
int basecolnum1/string basecolname1, string altcolname1, bool/int/double/string default1,
int basecolnum2/string basecolname2, string altcolname2, bool/int/double/string default2,
...
int basecolnumN/string basecolnameN, string altcolnameN, bool/int/double/string defaultN
);
Here:
basecolnumN - the number of the base column from which to take data. If -1, then there will be an empty column filled with the defaultN value;
basecolnameN - base column name can be specified here;
altcolnameN - alternative name of the column, if the value is "", then the name of the base column is taken;
defaultN - the value that will be displayed if an empty column (-1) is specified. If you set "", then there will be no padding.
Example.
ts_table(iTableMatRes, "mapping_columns_to_export",
-1, "Pos.", "",
"Name of material (Rus)", "Name and technical characteristics", "",
-1, "Type, brand, designation of the document, questionnaire", "",
-1, "Supplier", "",
"Unit of material", "Unit", "",
"Material Qty", "Qty", "",
-1, "Weight of 1 unit, kg","",
-1, "Note", ""
);