Extract Records forn Array

[carlos_carreno]

Good afternoon, how can I extract the entries from this column and convert each entry into rows?

I need to extract the information from each entry and create a row for each of those entries.

thanks

[DavidRitter]

Hey Carlos,

You will want to do add a 'expand':

| expand array

[mosharref_hossn]

I believe you can use the "expand" command to flatten the array and parse out the data using JSON object naming convention. 

data record(value = "[{\"hello\" : \"world\"}]")
| parse value, "JSON_ARRAY:greeting"
| fields greeting
| expand greeting
| fieldsAdd greeting=greeting[hello]

---

@carlos_carreno wrote:

Good afternoon, how can I extract the entries from this column and convert each entry into rows?

I need to extract the information from each entry and create a row for each of those entries.

thanks

---