How to keep only unique items based on the specific key. In this case countryId . Data type is List of Dict

Question

local!test1: {
{
item: "stapler",
name: "Mike",
countryId: 1
},
{
item: "printer",
name: "Larry",
countryId: 2
},
{
item: "laptop",
name: "Mike",
countryId: 1
},
{
item: "glass",
name: "Mike",
countryId: 3
}
},

Stefan Helzle · Accepted Answer

a!localVariables(
 local!test1: {
 {
 item: "stapler",
 name: "Mike",
 countryId: 1
 },
 {
 item: "printer",
 name: "Larrys",
 countryId: 2
 },
 {
 item: "printer",
 name: "Larry",
 countryId: 2
 },
 {
 item: "laptop",
 name: "Mike",
 countryId: 1
 },
 {
 item: "glass",
 name: "Mike",
 countryId: 3
 }
 },


 a!forEach(
 items: union(local!test1.countryId,local!test1.countryId),
 expression: displayvalue(
 fv!item,
 local!test1.countryId,
 local!test1,
 null
 )
 )
)

How to keep only unique items based on the specific key. In this case countryId . Data type is List of Dict

Top Replies