A mapping template tells the platform how to read one file shape: which columns it has, which canonical field each column fills, and how to parse dates, numbers and currency in it. A template is data, not code: a new file shape from the same source is a new template, never a new build.
Example: one returns template. Each column carries exactly one transform; the dedupe key makes a re-upload an update.
A transform converts one source column into one canonical field. The set is closed: a new kind changes the transform library, not a template. Amounts are whole VND; decimal is never used for money.
Kind
What it does
pass
Keeps the raw string unchanged
string
Trims, case-folds and collapses whitespace, with a fallback for empty values
int, decimal
Strips thousands separators and currency symbols; options for multiplier and parentheses-as-negative
date
Parses against a declared format and emits a calendar date or a timestamp
bool
Reads a truthy or falsy flag; an empty cell stays unknown, never false
enum
Maps a source value to a canonical one; unmatched values default, reject or pass
concat, constant, product
Joins several columns; emits a fixed value; multiplies two numeric columns (price times quantity)
param
Reads a value the uploader supplied for this run, named in parameters
code_map, split_list
Maps a code through a declared table; splits a delimited cell into a list