---
title: "IndexFromOverlap"
slug: "indexfromoverlap"
updated: 2025-10-21T14:09:21Z
published: 2025-10-21T14:09:21Z
canonical: "docs.datajet.app/indexfromoverlap"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# IndexFromOverlap

Outputs results of overlap report to the resolution table as new columns

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "IndexFromOverlap" | Outputs results of [overlap](/v1/docs/overlap) [report](/v1/docs/overlap-analysis) to the resolution table as new columns (i.e., Attach Fields to Table) |
| collection | "CollectionName" | Collection containing the datasets to overlap. One of either Collection or dataSet(s) must be provided. |
| dataSet{} dataSets[] | "datasetObject" "datasetObjects" | The input datasets to overlap. One of either Collection or dataSet(s) must be provided. see [dataset](/v1/docs/dataset-1) |
| fields[] | [ "fieldList" "fieldList" ] |  |
| overwrite | true/false | If true, existing fields will be over-written. |
| prefix | "PrefixString" | Prefix to attach to column names of created fields. |
| table | "TableName" | Table to export to |

{Explanation}

```json
{
  "method": "IndexFromOverlap",
  "table": "sales",
  "prefix": "overlap1-",
  "collection": "Sales Collection",
  "dataSet": {
    "logic": "or",
    "name": "segment_Corporate",
    "strict": true,
    "set": [
      {
        "logic": "and",
        "stype": "FIELD",
        "entity": {
          "type": "field",
          "name": "sales.segment",
          "table": "sales",
          "valueFilter": []
        },
        "op": "=",
        "values": [
          "Corporate"
        ]
      }
    ]
  },
  "project": "Rg2-Demo"
}
```

```json
{
  "method": "IndexFromOverlap",
  "table": "sales",
  "-keepTempObjects": true,
  "-fields": [
    "index",
    "target"
  ],
  "overwrite": true,
  "prefix": "overlap1-",
  "dataSets": [
    {
      "logic": "or",
      "name": "DS1",
      "strict": true,
      "set": [
        {
          "logic": "or",
          "stype": "FIELD",
          "entity": {
            "type": "field",
            "name": "sales.DS1",
            "table": "sales",
            "valueFilter": []
          },
          "op": "=",
          "values": [
            "1"
          ]
        }
      ]
    },
    {
      "logic": "or",
      "name": "DS2",
      "strict": true,
      "set": [
        {
          "logic": "or",
          "stype": "FIELD",
          "entity": {
            "type": "field",
            "name": "sales.DS2",
            "table": "sales",
            "valueFilter": []
          },
          "op": "=",
          "values": [
            "1"
          ]
        }
      ]
    },
    {
      "logic": "or",
      "name": "DS3",
      "strict": true,
      "set": [
        {
          "logic": "or",
          "stype": "FIELD",
          "entity": {
            "type": "field",
            "name": "sales.DS3",
            "table": "sales",
            "valueFilter": []
          },
          "op": "=",
          "values": [
            "1"
          ]
        }
      ]
    },
    {
      "logic": "or",
      "name": "DS4",
      "strict": true,
      "set": [
        {
          "logic": "or",
          "stype": "FIELD",
          "entity": {
            "type": "field",
            "name": "sales.DS4",
            "table": "sales",
            "valueFilter": []
          },
          "op": "=",
          "values": [
            "1"
          ]
        }
      ]
    }
  ],
  "names": [
    "DSet 1",
    "DSet 2",
    "DSet 3",
    "DSet 4"
  ],
  "dataSet": {
    "logic": "or",
    "name": "segment_Corporate",
    "strict": true,
    "set": [
      {
        "logic": "and",
        "stype": "FIELD",
        "entity": {
          "type": "field",
          "name": "sales.segment",
          "table": "sales",
          "valueFilter": []
        },
        "op": "=",
        "values": [
          "Corporate"
        ]
      }
    ]
  },
  "project": "Rg2-Demo"
}
```