Sheet transforms

Sheet transforms validate and transform data within a single tabular file against a OneSchema template — the same template logic used in OneSchema's standard import workflows. This includes type coercion, required-field checks, and any custom validation or transformation rules defined on the template.

Availability: GA

What it does

• Input: one or more CSV lists.
• Output: one or more CSV lists, validated and transformed according to the columns, types, and rules defined in your selected template.
• The transform applies the template's column definitions to the input: coercing types, applying formatting rules, and flagging cells or rows that do not conform. Nonconforming rows are not automatically corrected or removed; they are reported as errors in the output.

When to use it

• You already have (or want to build) a OneSchema template that defines your target schema and validation rules.
• You need consistent type-casting and formatting normalization applied to incoming data.
• You want detailed, per-cell error reporting similar to a standard OneSchema import.

How to configure it

Add a Sheet transforms node after the node that produces the CSV list you want to validate, then select the template to apply.

Settings

Example

Input

A CSV with a State column containing a mix of full state names and two-letter abbreviations.

Output

A CSV where State is normalized to two-letter codes per the template's transformation rule, with any values that can't be resolved flagged as errors.

Troubleshooting

Rows fail validation unexpectedly

• Check the template's required fields and data types against your actual input data.
• Review the template's custom validation rules for logic that may be stricter than intended.

Output columns are reordered

• Sheet transforms outputs columns in the order defined by the template. Adjust the template's column order if you need a different output order.

See also

• CSV transforms agent
• Template transforms agent
• Custom SQL transforms