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", ""
);