Outputs results of overlap report to the resolution table as new columns
| Key | Value(s) | Description |
|---|---|---|
| method | "IndexFromOverlap" | Outputs results of overlap report 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 |
| 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}
{
"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"
}
{
"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"
}