# Data intersection
**URL:** https://discuss.elastic.co/t/data-intersection/301351
**Category:** Kibana
**Tags:** kql-kibana-query-language
**Created:** [April 1, 2022, 4:03pm UTC](https://discuss.elastic.co/t/data-intersection/301351 "2022-04-01T16:03:01Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@ratel\_joun](https://discuss.elastic.co/u/ratel_joun)
#### Post date: [April 1, 2022, 4:03pm UTC](https://discuss.elastic.co/t/data-intersection/301351/1 "2022-04-01T16:03:02Z")
hello everybody,
can anyone answer how to get the intersection between data in two fields in the same index, in other words the data found in field1 and field2 but not at the same row.
for example, i want to get the subscriberID (5946) found in field "Seller" and this same subscriber is a "Buyer" in other rows
---
### Author:  [@msanz-acclaro](https://discuss.elastic.co/u/msanz-acclaro)
#### Post date: [April 1, 2022, 5:47pm UTC](https://discuss.elastic.co/t/data-intersection/301351/2 "2022-04-01T17:47:48Z")
```auto
subscriberID : 5946 OR Seller : 5946 OR Buyer : 5946
```
will pull all the records that match either of those fields.
You can also just file a search as this
```auto
5946
```
which will run the search somewhat globally, but may also match results like `15946` or `59460`, etc
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 29, 2022, 5:47pm UTC](https://discuss.elastic.co/t/data-intersection/301351/3 "2022-04-29T17:47:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.