---
title: Model: Coalesce
slug: data-platform/api/model-coalesce
docTags: 
createdAt: 2026-09-04T17:08:55.471Z
---

### Code examples

```json
{
  "sources": [
    {
      "combination": {
        "conjunction": "CONJUNCTION_NOT_SET",
        "expressions": [
          {
            "": ""
          }
        ]
      },
      "comparison": {
        "lhs": {
          "": ""
        },
        "comparator": "COMPARATOR_NOT_SET",
        "rhs": {
          "": ""
        }
      },
      "path_reference": {
        "value": ""
      },
      "string_literal": {
        "value": ""
      },
      "number_literal": {
        "value": ""
      },
      "boolean_literal": {
        "value": false
      },
      "is_missing": {
        "source": {
          "": ""
        }
      },
      "is_not_missing": {
        "source": {
          "": ""
        }
      },
      "false_or_missing": {
        "source": {
          "": ""
        }
      },
      "true_or_missing": {
        "source": {
          "": ""
        }
      },
      "coalesce": {
        "": ""
      },
      "truncate_time": {
        "source": {
          "": ""
        },
        "unit": "TIME_UNIT_NOT_SET",
        "timezone": {
          "": ""
        }
      },
      "shift_time": {
        "source": {
          "": ""
        },
        "amount": {
          "": ""
        },
        "unit": "TIME_UNIT_NOT_SET",
        "timezone": {
          "": ""
        }
      },
      "any_of_string": {
        "needle": {
          "": ""
        },
        "haystack": [
          ""
        ]
      },
      "any_of_number": {
        "needle": {
          "": ""
        },
        "haystack": [
          ""
        ]
      },
      "none_of_string": {
        "needle": {
          "": ""
        },
        "haystack": [
          ""
        ]
      },
      "none_of_number": {
        "needle": {
          "": ""
        },
        "haystack": [
          ""
        ]
      },
      "like_any_of_string": {
        "needle": {
          "": ""
        },
        "haystack": [
          ""
        ]
      },
      "like_none_of_string": {
        "needle": {
          "": ""
        },
        "haystack": [
          ""
        ]
      },
      "is_list_member": {
        "list": ""
      },
      "is_not_list_member": {
        "list": ""
      }
    }
  ]
}
```