Date Standardization Rule (date_standardization) β
Converts date formats from one pattern to another.
| Field | Description | Required |
|---|---|---|
current_format | The format of the existing date string (e.g., "%d-%m-%Y"). | β Yes |
new_format | The desired output format (e.g., "%Y-%m-%d"). | β Yes |
Example: β
json
{
"type": "date_standardization",
"source_column": "transaction_date",
"destination_column": "",
"current_format": "%d-%m-%Y",
"new_format": "%Y-%m-%d"
}Behavior: Converts dates from "DD-MM-YYYY" format to "YYYY-MM-DD".