Index Array with Nested arrays

Question

Hello, 
 I'm having this problem: 
 I have to divide an array when 2 conditions are met (same name and country). 
 I've resolved this problem using "whereContains(firstCondition)" interescting it with "whereContains(Second Condition)" 
 
 Now i have this nested array:

Now i would like to index the Numbers Arrays into ri!array, but i can't find a way other then 2 nested a!forEach to fv!item every array. 
 
 How can i make the 2 nested a!forEach work? 
 
 Or do you have some other ideas? 
 
 Thanks

Mike Schmitt · Accepted Answer

Consider this alternate implementation (i made up my own structure for ri!array as you hadn't replied yet, but I think it's similar enough to fit into your data model) 
 a!localVariables(
 local!array: {
 {
 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!allNameCountryPairs: a!forEach(
 local!array,
 {
 name: fv!item.name,
 countryId: fv!item.countryId
 }
 ),
 local!uniqueNameCountryPairs: union(local!allNameCountryPairs, local!allNameCountryPairs),

 a!forEach(
 local!uniqueNameCountryPairs,
 a!localVariables(
 local!currentEntry: fv!item,
 a!forEach(
 local!array,
 if(
 and(
 local!currentEntry.name = fv!item.name,
 local!currentEntry.countryId = fv!item.countryId
 ),
 fv!item,
 {}
 )
 )
 )
 )
) 
 Here, instead of worrying about grabbing indices for the unique names / country IDs and trying to do a complicated extraction of the overlaps, we instead simply get a list of all unique name/countryId pairs first, then iterate over that list and (inside) iterate over the original list and return any entries where the values match. Output below:

Mike Schmitt · Answer

Just FYI - wherecontains() already accepts 2 array parameters, so you might not even need to a!forEach() over ri!array.name . 
 Also: have you tried passing your current output through the a!flatten() function yet?

Index Array with Nested arrays

Top Replies