Filter A Collection

Input collection: myTrucks39

Year	Make	Model
2020	Ford	F150
2018	Chevy	Silverado
2019	Ford	F150
2020	Chevy	Avalanche
2017	Chevy	Silverado
2016	GM	Yukon

Output collection: mySolution39 (filter on equals ‘Chevy’ Make)

Year	Make	Model
2018	Chevy	Silverado
2020	Chevy	Avalanche
2017	Chevy	Silverado

Solution code:

//Create a collection
ClearCollect(myTrucks39,
{Year: 2020, Make: "Ford", Model: "F150"},
{Year: 2018, Make: "Chevy", Model: "Silverado" },
{Year: 2019, Make: "Ford", Model: "F150" },
{Year: 2020, Make: "Chevy",Model: "Avalanche"},
{Year: 2017, Make: "Chevy", Model: "Silverado"},
{Year: 2016, Make: "GM", Model: "Yukon"}
);

//Filter collection code
ClearCollect(
    mySolution39,
    Filter(myTrucks39,Make="Chevy")
);