Getting Data In

How to run a nested loop?

aditya
Engager

Hi,

I have one field containing an array within an array.

How can I run a for loop to query the nested arrays and display them?

Eg :-

Dept_details : [

{name:"cse", HOD:"somename", students:[

{name:"aditya", rollNo:"1"}, {name:"akash", rollNo="2"}

]

},

{

name:"ece", HOD:"somename2", students:[

{name:"abhiram", rollNo:"1"}, {name:"abhay", rollNo="2"}

]

}

]

 

I expect the results to be like this :-

Dept_details

name                    hod

cse                        someone

 

student details

name                 rollNo

aditya                1

akash                  2

 

dept details

name                    hod

ise                        someone2

 

student details

name                 rollNo

abhiram           1

abhay               2

 

Thanks,

Aditya

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

I am not sure you can easily get the representation you are showing, however,  you could try something like this to break up the data

| spath path=Dept_details output=Dept_details
| mvexpand Dept_details
| spath input=Dept_details

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

I am not sure you can easily get the representation you are showing, however,  you could try something like this to break up the data

| spath path=Dept_details output=Dept_details
| mvexpand Dept_details
| spath input=Dept_details
0 Karma

aditya
Engager

Hi @ITWhisperer ,

The events which are getting logged for my project can have same id. So, on running mvexpand, it lists the contents of all array of all events. That's why I need to run a for loop somehow. Otherwise I can't calculate no of depts in dept_details.

Can you help with this?

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

I am not sure where id is coming from since it isn't in the example you shared - if you need the count of dept_details

| spath path=Dept_details output=Dept_details
| eval Dep_t_count=mvcount(Dept_details)
0 Karma

aditya
Engager

Ok, got it. Thanks for your help!!

0 Karma
Get Updates on the Splunk Community!

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...