Input collection: myTrucks51
Serial | Year | Make | Model |
8943 | 2020 | Ford | F150 |
4623 | 2018 | Chevy | Silverado |
2315 | 2019 | Ford | F150 |
5466 | 2020 | Chevy | Avalanche |
Output collection: mySolution51
Serial | Year | Make | Model |
Solution code:
//Create a collection
ClearCollect(myTrucks51,
{Serial: 8943, Year: 2020, Make: "Ford", Model: "F150"},
{Serial: 4623, Year: 2018, Make: "Chevy", Model: "Silverado" },
{Serial: 2315, Year: 2019, Make: "Ford", Model: "F150" },
{Serial: 5466, Year: 2020, Make: "Chevy",Model: "Avalanche"}
);
//Clear all rows code
ClearCollect(mySolution51, myTrucks51);
Clear(mySolution51);