Knowledge Management

combine multi value field with single value field in json

Cbr1sg
Path Finder

Hi all,

I have this json file like below:

 

rootfield: [[-]	
     {[-]	       
       field 1: A       
       field 2: [[-]	
         value1
         value2	
       ]
     }
     {[-]	       
       field 1: B       
       field 2: [[-]	
         value1
         value2
         value3
         value4
       ]
     }
     {[-]	       
       field 1: C       
       field 2: [[-]	
         value1
         value3
         value4
       ]
     }

 

I want to extract the result to look like this

A_value1,value2
B_value1,value2,value3,value4
C_value1,value3,value4

i know combination of spath and mvexpand will work but I want to avoid mvexpand because it's eating memory and our json file is huge. Would be nice to be able to get the data without mvexpand.

Thanks

 

Labels (1)
0 Karma
Get Updates on the Splunk Community!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...