Input collection: myCars45
| SerialNo | Year | Make | Model |
| 6453 | 2016 | Toyota | Corolla |
| 8946 | 2014 | Honda | Civic |
| 3571 | 2019 | Toyota | Camry |
| 1165 | 2018 | Honda | Civic |
| 8973 | 2018 | Hyundai | Elantra |
| 4529 | 2020 | Honda | Accord |
Output collection: mySolution45
| SerialNo |
| 6453 |
| 8946 |
| 3571 |
| 1165 |
| 8973 |
| 4529 |
Solution code:
//Create a collection
ClearCollect(myCars45,
{SerialNo:"6453", Year: 2016, Make: "Toyota", Model: "Corolla"},
{SerialNo:"8946",Year: 2014, Make: "Honda", Model: "Civic" },
{SerialNo:"3571",Year: 2019, Make: "Toyota", Model: "Camry" },
{SerialNo:"1165",Year: 2018, Make: "Honda",Model: "Civic"},
{SerialNo:"8973",Year: 2018, Make: "Hyundai", Model: "Elantra"},
{SerialNo:"4529",Year: 2020, Make: "Honda", Model: "Accord"}
);
//Get a column from a collection code
ClearCollect(mySolution45,myCars45.SerialNo);