Column mapping: Fx rates

Mappings · approved version 1

Canonical fields and suggestions

Canonical fields
Field	Required	Approved source	Suggested source	Notes
rate_date	required	Date	Date(synonym)	—
base_currency	required	Currency Pair	—	—
quote_currency	required	Currency Pair	—	—
rate	required	Rate	Rate(exact)	—

Unmatched columns: Currency Pair. Start from the suggestion

Edit and preview

Mapping (JSON)

{
  "fields": {
    "base_currency": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "regex_extract",
          "group": 1,
          "pattern": "^([A-Z]{3})/"
        },
        {
          "step": "currency"
        }
      ],
      "source": "Currency Pair"
    },
    "quote_currency": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "regex_extract",
          "group": 1,
          "pattern": "/([A-Z]{3})$"
        },
        {
          "step": "currency"
        }
      ],
      "source": "Currency Pair"
    },
    "rate": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_decimal"
        }
      ],
      "source": "Rate"
    },
    "rate_date": {
      "steps": [
        {
          "step": "trim"
        },
        {
          "step": "parse_date",
          "format": "YYYY-MM-DD"
        }
      ],
      "source": "Date"
    }
  },
  "exclude_rows_where_blank": []
}

View-only in public demo

Preview a mapping to propose it.

Versions

Version 1 approvedchange request