Show data table only Prefix data

[Waranon (Piasri)]

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

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

WaranonP
Thank you

[lukeelmers]

Hi @Waranon,

You should be able to achieve what you're looking for using scripted fields.

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