How to insert nested records having different schema from one to another BQ table

Steffy Alen

Source Table SCHMEA

enter image description here

Target Table SCHEMA

enter image description here

I’m trying to copy Source table records into targed table and am running into the following error Query column 2 has type ARRAY<STRUCT<Name STRING, Value STRING>> which cannot be inserted into column request, which has type STRUCT<movie ARRAY<STRUCT<name STRING, Budget STRING

INSERT INTO `<GCP_PROJECT_NAME>.Test_Tables.Nested_Person_Table2` 
  (Actor,
  director)
SELECT
  protagonist,
  STRUCT([STRUCT(mo.Name as Name, mo.Budget as Budget)] as movie, "" as language, "" as 
English, "" as other, STRUCT("","") as source) as director
FROM
`<GCP_PROJECT_NAME>.Dataset.Table`, UNNEST(movie) as mo

Expected output:

All the records present in the source table should be sit into target table.