add_field

向记录添加字段

向记录添加字段

选项 1（备选）：添加多个字段

性能

名字 类型 描述 必填
领域 object[] 领域
 是的

其他属性：不允许

例

source:
  server_name: redislabs
  schema: dbo
  table: emp
transform:
  - uses: add_field
    with:
      fields:
        - field: name.full_name
          language: jmespath
          expression: concat([name.fname, ' ', name.lname])
        - field: name.fname_upper
          language: jmespath
          expression: upper(name.fname)

Option 2 (alternative): Add one field

Properties

Name Type Description Required
field string Field
 yes
expression string Expression
 yes
language string Language
Enum: "jmespath", "sql"
 yes

Additional Properties: not allowed

Example

source:
  server_name: redislabs
  schema: dbo
  table: emp
transform:
  - uses: add_field
    with:
      field: country
      language: sql
      expression: country_code || ' - ' || UPPER(country_name)

Option 1: fields[]: array

Fields

Items

Item Properties

Name Type Description Required
field string Field
 yes
expression string Expression
 yes
language string Language
Enum: "jmespath", "sql"
 yes

Item Additional Properties: not allowed

Example

- {}
RATE THIS PAGE
Back to top ↑