# How to pass multiple values from Data Table for next drilldown to filter data?
**URL:** https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801
**Category:** Kibana
**Created:** [February 18, 2020, 1:46pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801 "2020-02-18T13:46:07Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@venkata.kodapaka](https://discuss.elastic.co/u/venkata.kodapaka)
#### Post date: [February 18, 2020, 1:46pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801/1 "2020-02-18T13:46:07Z")
Hi Team,
I've built a Visualization as Data Table as Summary report in which I have multiple columns. When I click on any cell, it has to open the respective drilldown data where in which Column1 and Column2 have to be passed(to filter the respective data).
When I googled it, some body suggested that can't be done using URL parameter(only 1 value passing is possible with URL parameter) and need to use Scripted fields for this requirement.
But I'm unable to do it so. Could you please help me in this regard, please let me know if you need any further clarification. Any help will be highly appreciated. Thanks in advance.
---
### Author:  [@tims](https://discuss.elastic.co/u/tims)
#### Post date: [February 18, 2020, 8:26pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801/2 "2020-02-18T20:26:07Z")
Hi @venkata.kodapaka, you are correct in that filtering on multiple columns is currently not possible in dashboards. Here is the github issue tracking this request:
>
>
> Hi, I'd like to allow business users of our dashboard to select multiple values from a graph/table to filter the dashboard...
Here's the docs on creating scripted fields:
[https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html)
Where are you getting stuck on scripted fields?
---
### Author:  [@venkata.kodapaka](https://discuss.elastic.co/u/venkata.kodapaka)
#### Post date: [February 19, 2020, 5:12am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801/3 "2020-02-19T05:12:20Z")
Hi @tims,
Thanks for the reply and confirmation.
I've checked that youtube tutorial([https://www.youtube.com/watch?v=MLSv9oOHXzg](https://www.youtube.com/watch?v=MLSv9oOHXzg)) on how to Create drilldown and able to successfully pass 1 value and able to filter data.
But I need to pass 2 columns value from the Data table in my requirement.
I've checked the one of the discussion topic on the similar requirement but unable to configure in my case.
> [@How to pass multiple field values of a table to URL](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/7):
>
> @softec17 @sravya to create a Scripted Field, you select Management -\> Index Patterns And then Scripted Fields -\> Add Scripted Field If you create a scripted field with a Type of "string", a Format of "url" and the Script of: 'http://testwebsite.com/' + doc['geo.dest'].value + '/' + doc['geo.src'].value it'll create a URL using two fields from the document
I'm unable to know exactly how to use scripted fields to pass the data table values.
Is it possible to pass 2 column values from Data Table upon clicking URL and filter data based on them in anyway(at least with scripted fields)?
Could you please help me on this as quickly as possible.
---
### Author:  [@tims](https://discuss.elastic.co/u/tims)
#### Post date: [February 19, 2020, 1:48pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801/4 "2020-02-19T13:48:35Z")
@venkata.kodapaka I think the idea would be that you use scripted fields to concatenate the 2 values together into a new field. Then you can filter on the new field by passing in 1 value with the 2 values concatenated together. It is admittedly a hacky solution at best.
---
### Author:  [@venkata.kodapaka](https://discuss.elastic.co/u/venkata.kodapaka)
#### Post date: [February 20, 2020, 9:54am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801/5 "2020-02-20T09:54:46Z")
Hi @tims,
Thanks a ton, I understand your idea and able to implement it.
I've implemented concatenation like Column1|Column2(joined with pipe(|) symbol in between)
One more thing I would like to know is, Is there any possibility to show different in Data Table(like Column1 only) but URL should contain Column1|Column2 to filter data as expected?
Thanks in advance.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 19, 2020, 9:54am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-values-from-data-table-for-next-drilldown-to-filter-data/219801/6 "2020-03-19T09:54:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.