how to remove multiple key from this list of dictionary. I did it like this i want some better solution using remove

Question

a!localVariables(
 local!array: cast(
 97,
 {
 {
 item: "stapler",
 name: "Mike",
 countryId: 1
 },
 {
 item: "printer",
 name: "Larry",
 countryId: 2
 },
 {
 item: "laptop",
 name: "Mike",
 countryId: 1
 },
 {
 item: "glass",
 name: "Mike",
 countryId: 3
 }
 }
 ),
 local!updatedArray: a!forEach(
 items: local!array,
 expression: remove(fv!item,"item")
 ),
 local!finalArray: a!forEach(
 items: local!updatedArray,
 expression: remove(fv!item,"name")
 ),
 local!finalArray
)

amir.karami · Accepted Answer

Try: a!localVariables(
 local!array: cast(
 97,
 {
 {
 item: "stapler",
 name: "Mike",
 countryId: 1
 },
 {
 item: "printer",
 name: "Larry",
 countryId: 2
 },
 {
 item: "laptop",
 name: "Mike",
 countryId: 1
 },
 {
 item: "glass",
 name: "Mike",
 countryId: 3
 }
 }
 ),
 a!forEach(
 items:local!array,
 expression: reduce(fn!remove,fv!item,{"name","item"})
 )

)

amir.karami · Answer

Ok, your dictionary is actually not quite duplicate since country ids are the same but items are not the same, but if you really want to remove one of the duplicate countryIds, I don't know which one, try this code and see my comments: a!localVariables(
 local!array: cast(
 97,
 {
 {
 item: "stapler",
 name: "Mike",
 countryId: 1
 },
 {
 item: "printer",
 name: "Larry",
 countryId: 2
 },
 {
 item: "laptop",
 name: "Mike",
 countryId: 1
 },
 {
 item: "glass",
 name: "Mike",
 countryId: 3
 }
 }
 ),
 local!filteredArray:a!forEach(
 items:local!array,
 expression: reduce(fn!remove,fv!item,{"name"})
 ),
 /*Find the duplicate items indexes*/
 local!duplicateCountryIdsIndexes: where(
 a!forEach(
 items: local!filteredArray,
 expression: contains(
 remove(local!filteredArray.countryId, fv!index),
 fv!item.countryId,

 )
 )
 ),
 
 /*To return the duplicae items*/
 local!duplicateItems: local!filteredArray[local!duplicateCountryIdsIndexes],

 /* Remove one of the duplicates, let's say the last item as I don't know which one you need
 to keep. length(local!duplicateCountryIdsIndexes) will give you the last item, if you want to keep
 the first item simply use 1 instead of length(local!duplicateCountryIdsIndexes)
 */
 local!duplicateItemToRemove:if(
 a!isNotNullOrEmpty(local!duplicateItems),
 remove(local!duplicateItems,length(local!duplicateCountryIdsIndexes)),
 null
 ),

 difference(
 local!filteredArray,
 local!duplicateItemToRemove
 )

)

how to remove multiple key from this list of dictionary. I did it like this i want some better solution using remove

Top Replies