Add Field - Redis — ContextQMD

Add fields to a record

Option 1 (alternative): Add multiple fields

Properties

Name	Type	Description	Required
fields	`object[]`	Fields
yes

Additional Properties: not allowed

Example

yaml

source:
  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      |

Additional Properties: not allowed

Example

yaml

source:
  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      |

Item Additional Properties: not allowed

Example

yaml

- {}