title: Big query DML insert-select as into repeated tables
body: <p>I have a table structure (table name: Recalled_transaction) as follows:</p>
  
  <pre><code>[{
  "name": "STR_NBR",
  "type": "STRING",
  "mode": "NULLABLE"
  },
  {
  "name": "RGSTR_NBR",
  "type": "INTEGER",
  "mode": "NULLABLE"
  },
  {
  "name": "POS_TRANS_ID",
  "type": "INTEGER",
  "mode": "NULLABLE"
  },
  {
   "name": "SLS_DT",
  "type": "DATE",
  "mode": "NULLABLE"
  },
  {
  "name": "TRANS_ORIG_SRC",
  "type": "RECORD",
  "mode": "REPEATED",
  "fields": [
    {
    "name": "POS_APPL_TYP_CD",
    "type": "STRING",
    "mode": "NULLABLE"
    },
    {
    "name": "USER_ID",
    "type": "STRING",
    "mode": "NULLABLE"
    }
   ]
  },
  {
  "name": "RECALLED_TXN",
  "type": "RECORD",
  "mode": "REPEATED",
  "fields": [
    {
    "name": "POS_SEQ_NBR",
    "type": "STRING",
    "mode": "REPEATED"
    },
    {
    "name": "SUB_SYS_CD",
    "type": "STRING",
    "mode": "NULLABLE"
    }
   ]
   }
   ]
  </code></pre>
  
  <p>I would like to insert from a set of regular tables into this structure using insert-select as (DML in standard sql).  Has anyone done before.  Any help is appreciated.</p>
  
  <p>Thanks</p>