
# add\_field

Add fields to a record

Add fields to a record

**Option 1 (alternative):** Add multiple fields

**Properties**

Name

Type

Description

Required

[**fields**](#option1fields)

`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

**expression**

`string`

Expression  

yes

**language**

`string`

Language  
Enum: `"jmespath"`, `"sql"`  

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

**expression**

`string`

Expression  

yes

**language**

`string`

Language  
Enum: `"jmespath"`, `"sql"`  

yes

**Item Additional Properties:** not allowed

**Example**

```yaml
- {}
```

## On this page
