topic Re: Extract Records forn Array in DQL

Extract Records forn Array

carlos_carreno — Fri, 01 Nov 2024 22:20:04 GMT

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

Re: Extract Records forn Array

DavidRitter — Thu, 07 Nov 2024 13:34:43 GMT

Hey Carlos,

You will want to do add a 'expand':

| expand array

Re: Extract Records forn Array

mosharref_hossn — Tue, 12 Nov 2024 21:45:25 GMT

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