Insert Multiple Rows Into A Collection

Input collection: myTestScores32a

FullNameAge TestScore
David Jones3278
Anne Lisbon4592
Penlope Parra2656


Input collection: myTestScores32b

FullNameAge TestScore
Harold Reimer5065
Jerry Farrel1873
Stacy Fenton3584


Output collection: mySolution32

FullNameAge TestScore
David Jones3278
Anne Lisbon4592
Penlope Parra2656
Harold Reimer5065
Jerry Farrel1873
Stacy Fenton3584


Solution code:

//Create a collection
ClearCollect(myTestScores32a,
{FullName:"David Jones", Age: 32, TestScore: 78},
{FullName:"Anne Lisbon", Age: 45, TestScore: 92},
{FullName:"Penelope Parra", Age: 26, TestScore: 56}
);

//Create multiple rows
ClearCollect(
    myTestScores32b,
    {FullName:"Harold Reimer", Age: 50, TestScore: 65},
    {FullName:"Jerry Farrel", Age: 18, TestScore: 73},
    {FullName:"Stacy Fenton", Age: 35, TestScore: 84}
);

//Insert multiple new rows into collection code
ClearCollect(mySolution32,myTestScores32a);
Collect(mySolution32,myTestScores32b);