# Display partially structured data into multiple columns in Kibana Discover

**URL:** <https://discuss.elastic.co/t/display-partially-structured-data-into-multiple-columns-in-kibana-discover/347254>\
**Category:** Elasticsearch\
**Tags:** painless\
**Created:** [November 15, 2023, 8:14pm UTC](https://discuss.elastic.co/t/display-partially-structured-data-into-multiple-columns-in-kibana-discover/347254 "2023-11-15T20:14:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Selma](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@Selma](https://discuss.elastic.co/u/Selma)\
**Post date:** [November 15, 2023, 8:14pm UTC](https://discuss.elastic.co/t/display-partially-structured-data-into-multiple-columns-in-kibana-discover/347254/1 "2023-11-15T20:14:24Z")

</div>

I am trying to get the data as separate columns based on the fields serviceName, flowName, correlationId and timestamp from below log field. can this be achieved through scripts in Kibana UI itself ? If not is there an alternative for this ?

[2023-11-15 13:59:41.146] INFO info [[MuleRuntime].uber.512: [mule-sys].post:\accounts:application\json:mule-sys-api-config.CPU\_LITE @720d4er4] [event: xxx]: {  
"muleMessage": {  
"messageType": "Request",  
"responseStatus": "Success",  
"serviceName": "Account Status ",  
"flowName": "post:\accounts:application\json:mule-sys-api-config",  
"correlationId": "xxx",  
"timestamp": "2023-11-14T14:59:41.145Z",  
}  
}

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [November 22, 2023, 10:11pm UTC](https://discuss.elastic.co/t/display-partially-structured-data-into-multiple-columns-in-kibana-discover/347254/2 "2023-11-22T22:11:25Z")

</div>

Hello,

What is the version of your stack? We release ES|QL in 8.11.0 which would definitely help with this.

[https://www.elastic.co/elasticsearch/piped-query-language](https://ES%7CQL)

> **[ES|QL commands | Elasticsearch Guide \[8.11\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/esql-commands.html)**

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 20, 2023, 10:11pm UTC](https://discuss.elastic.co/t/display-partially-structured-data-into-multiple-columns-in-kibana-discover/347254/3 "2023-12-20T22:11:43Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.