# Show data table only Prefix data

**URL:** <https://discuss.elastic.co/t/show-data-table-only-prefix-data/167214>\
**Category:** Kibana\
**Created:** [February 6, 2019, 4:17am UTC](https://discuss.elastic.co/t/show-data-table-only-prefix-data/167214 "2019-02-06T04:17:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Waranon](https://avatars.discourse-cdn.com/v4/letter/w/ecc23a/32.png) [@Waranon](https://discuss.elastic.co/u/Waranon)\
**Post date:** [February 6, 2019, 4:17am UTC](https://discuss.elastic.co/t/show-data-table-only-prefix-data/167214/1 "2019-02-06T04:17:44Z")

</div>

Now I can do it like this. It's not my expected.

 ![2019-02-06%2010_55_48-Kibana](https://us1.discourse-cdn.com/elastic/original/3X/a/f/af4cc9455658f2f107a7cf97981fe5036c9a4bf2.png)

Can we show data table only prefix string I want to group data like this?

 ![xlsx%20-%20Excel](https://us1.discourse-cdn.com/elastic/original/3X/6/d/6dfe334b4be785b7f1af6bbd806881a55459c093.png)

WaranonP  
Thank you

---

<div class="post-metadata">

**Author:** ![lukeelmers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukeelmers/32/35230_2.png) [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)\
**Post date:** [February 9, 2019, 12:36am UTC](https://discuss.elastic.co/t/show-data-table-only-prefix-data/167214/2 "2019-02-09T00:36:32Z")

</div>

Hi @Waranon,

You should be able to achieve what you're looking for using [scripted fields](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html).

You can create a new scripted field that concatenates data from the two fields, then use the new scripted field in your table visualization instead.

For example, a painless script would probably look something like this:

```
doc['Method'].value + ' ' + doc['URL'].value 

```

Just as a heads up though: if you are frequently needing to display this data in visualizations, you'll get better performance by combining the fields at indexing time instead.

Hope this helps a bit!

Luke

---

<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:** [March 9, 2019, 12:36am UTC](https://discuss.elastic.co/t/show-data-table-only-prefix-data/167214/3 "2019-03-09T00:36:36Z")

</div>

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