Ruby rails how do i get values from an array within an array within an array?

Question

I want to get values from a JSON array which I can assign to a table column, however one of the values I need is in an array within an array, within an array. For example, an array of employees and for each employee there is an array of departments which contains an array of floors.

{"employees": [{"name": "bob", "age": 20, "department": ["location": "head office", "floors":["ground", "basement"]], "grade": "supervisor"}]}

The name and age display as expected but I am unsure how to get the floors. I have tried several ways but I am unable to get the "floors". This is my latest attempt but it says invalid conversion of string to integer on the @employee[:department] line. Can someone advise the best way to get this value? Thanks

@employees.each do |i|
 employee[:column1] = i[:name]
 employee[:column2] = i[:age]

 @employee[:department].each do |d|
  employee[:column3] = d[:floors]
 end
end

Shouldn't it be i.[:department].each do |d|?

Vasilisa
– Vasilisa

2018-12-13 17:36:07 +00:00
Commented Dec 13, 2018 at 17:36 — Vasilisa
– Vasilisa, Commented Dec 13, 2018 at 17:36

genhernandez · Accepted Answer · 2018-12-13 17:47:40Z

1

The problem is that you're iterating over @employee[:department] when I think you want to be iterating over i[:department].

You could do

 @employees.values.flatten.each do |i|
     employee[:column1] = i[:name]
     employee[:column2] = i[:age]

     i[:department].each do |d|
         employee[:column3] = d[:floors]
     end
 end

answered Dec 13, 2018 at 17:47

genhernandez

4721 gold badge5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jvillian · Accepted Answer · 2018-12-13 18:09:39Z

0

You could give this a try:

@employees.each do |e|
  employee[:column1] = e[:name]
  employee[:column2] = e[:age]
  employee[:column3] = e[:department].last[:floors]
end

There's no need to iterate since the employee[:column3] = d[:floors] will always end up with the last element of the array. So, you can just go ahead and use last.

Saves you a couple of lines and some typing.

answered Dec 13, 2018 at 18:09

jvillian

20.3k5 gold badges33 silver badges45 bronze badges

Collectives™ on Stack Overflow

Ruby rails how do i get values from an array within an array within an array?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related