clean_replace
Replace values in a specified column using a custom mapping, with support for mapping to NULL to remove sentinel values like 'NA' or -999.
Instructions
New source with column values replaced per mapping.
Use the JSON value `null` (Python `None`) to map to SQL NULL — the
canonical way to remove sentinel values like 'NA' or -999.
Example: `mapping={"NA": null, "?": null, -999: null}`.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alias | No | ||
| column | Yes | ||
| mapping | Yes | ||
| source_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||