# Display dynamic data in columns **URL:** \ **Category:** Kibana\ **Created:** [January 19, 2022, 12:37pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812 "2022-01-19T12:37:21Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Post date:** [January 19, 2022, 12:37pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/1 "2022-01-19T12:37:21Z")
Hi all, In my project, the field names are dynamic as new indices keep getting pushed with different columns names. I cannot select a column name as they are not constant for all indices except time field and name field. How to dynamically display field names as columns ? Any way to do this ? I've explored SQL and logstash but not able to figure it out. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [January 21, 2022, 10:11pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/2 "2022-01-21T22:11:21Z")
> [@Sandeep\_Raju](#): > > dynamically display field names as columns Hi, what do you mean by this? Where to display? ---
**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Post date:** [January 22, 2022, 3:49pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/3 "2022-01-22T15:49:09Z")
I have different indices ( a1, a2, a3, a4...a30) with index pattern as a\* . They have different fields like `CREATED, created, Create_date, Create_time` I cant keep seperate column names `CREATED, created, Create_date, Create_time` as seperate term names(seperate columns) in kibana. So is there a way so that all field names are displayed dynamically instead of me setting term names in kibana visualization? ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [January 22, 2022, 10:53pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/4 "2022-01-22T22:53:42Z")
Ok, where in kibana visualization? kibana has a lot of visualization. As you said "columns", is it Discover? or Dashboard\>Lens\>Table, Dashboard\>Aggregation based\>Data table, or Canvas\>Data table? If you are saying about Discover, what is the setting of " Default columns" in Stack Management\>Advanced Settings. ---
**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Post date:** [January 23, 2022, 7:49am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/5 "2022-01-23T07:49:41Z")
I want to show in Data table. Every new index will have new field name. So I don't want to edit visualization every time a new index is pushed. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [January 23, 2022, 8:24am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/6 "2022-01-23T08:24:42Z")
There should be no way to automatically add fields to Data Table (possibly because how to aggregate the new field is not obvious), but if you inform the detail and purpose of the aggregation for the data table, there might be a workaround in some cases. ---
**Author:** ![raya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raya/32/55497_2.png) [@raya](https://discuss.elastic.co/u/raya)\ **Post date:** [January 26, 2022, 10:59pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/7 "2022-01-26T22:59:54Z")
@Sandeep_Raju I wonder why the column names keep changing? Maybe this should be fixed at ingest time by adding a standard column with a canonical name based on whatever source data has? ---
**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Post date:** [January 27, 2022, 8:40am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/8 "2022-01-27T08:40:38Z")
Let's say i have data coming from 5 different banks each having their own field names...and under them they have many clients having 5 different field names which are new.Like this new field names will be coming.It will be difficult for me to set field names again and again. So i was looking to display column names dynamically without specifiying them... SO i was looking in some way we can achieve this by logstash or setting or something... the closest i got was by using document table in enhanced table plugin using \_source as field , but it displays as a dump not as columns. ---
**Author:** ![raya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raya/32/55497_2.png) [@raya](https://discuss.elastic.co/u/raya)\ **Post date:** [January 27, 2022, 9:06pm UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/9 "2022-01-27T21:06:26Z")
Ah, I see. Thank you for the explanation! How would you determine which fields should be included? Or are you thinking to include all of them? ---
**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Post date:** [January 28, 2022, 2:31am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/10 "2022-01-28T02:31:28Z")
> [@Sandeep\_Raju](#): > > So i was looking to display column names dynamically without specifiying them... I want to display all the field values that are coming. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [January 28, 2022, 2:43am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/11 "2022-01-28T02:43:14Z")
Why do you want displaying them in one table? The table could be quite sparse. And have you considered about using saved search in Dashboard? ---
**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\ **Post date:** [January 28, 2022, 2:54am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/12 "2022-01-28T02:54:03Z")
Requirement is to show a detailed table of all the field data present in a document. Yes, I was thinking of saved search, but it shows a JSON file format. I want to display dynamic data with columns without selecting it everytime. I want to show in table format with columns. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [January 28, 2022, 3:49am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/13 "2022-01-28T03:49:24Z")
First of all, data tables (both lens or aggregation based) are showing aggregated data. If you want to show the data of documents, the possible choices are using discover or using saved search in dashboard. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [January 28, 2022, 5:22am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/14 "2022-01-28T05:22:18Z")
If you are using recent version of kibana, you may try new data table view of Discover which you can turn on via advanced setting of kibana. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 25, 2022, 5:23am UTC](https://discuss.elastic.co/t/display-dynamic-data-in-columns/294812/15 "2022-02-25T05:23:12Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.