CopyDownFromTemplate
  • 1 Minute to read
  • Dark
    Light
  • PDF

CopyDownFromTemplate

  • Dark
    Light
  • PDF

Article summary

Copies fields in specified field template from primary table to foreign table

KeyValue(s)Description
method"CopyDownFromTable"Copies fields in specified field template from primary table to foreign table
targetTable"TableToCopyFieldsTo"The name of the FOREIGN TABLE
template"FieldTemplateName"The name of the template on the PRIMARY TABLE
overwritetrue/falseIf true, existing fields will be overwritten
dataset{}{}Dataset of records to copy.
prefix"Prefix"Optional.  If provided, new fields will be prefixed with this value.
project"Project name"

JSON

{
  "method": "CopyDownFromTemplate",
  "project": "",
  "targetTable": "framingham",
  "template": "fi-all",
  "prefix": "MODEL1_",
  "overwrite": false,
  "dataSet": {
    "logic": "or",
    "name": "framingham_individual",
    "strict": true,
    "set": [
      {
        "logic": "or",
        "stype": "TABLE",
        "entity": "framingham_individual"
      }
    ]
  }
}

Right-click in the JSON window and choose from existing templates:



Template:


Source Table (Primary Table containing the template):

(Note this is primary to the other table, framingham


Target Table:




Was this article helpful?