Truncate Dates to Month Start
Convert CSV dates to month starts in a reusable structured transform
Transforms ISO dates in orders.csv to the first day of their month in a new month_start column, retaining the original data and direct source lineage.
About this Model
A reusable CSV date transformation model that creates one structured transform, Month Starts, directly from orders.csv. It retains the original order and date columns and adds month_start, converting each ISO date to the first day of its month. Repeated runs reuse the existing transform. A change request can update it in place to use the first day of each year while keeping the same output column. Reset removes generated results and side effects while preserving the source CSV and model structure; a subsequent run restores the default month-start transformation.
- Adds a month_start column
- Retains order and date columns
- Preserves direct CSV lineage
- Reuses one Month Starts transform
- Supports in-place year-start changes
- Resets generated state cleanly