# Data table split by columns, need to remove the data which is in both columns .. exclude that data

**URL:** <https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317>\
**Category:** Kibana\
**Created:** [May 2, 2019, 9:03am UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317 "2019-05-02T09:03:30Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![TEJASWI\_CHUNDURI](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tejaswi_chunduri/32/46271_2.png) [@TEJASWI\_CHUNDURI](https://discuss.elastic.co/u/TEJASWI_CHUNDURI)\
**Post date:** [May 2, 2019, 9:03am UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/1 "2019-05-02T09:03:30Z")

</div>

Hi ,

I had a Datatable, where split by columns , for example a ( build versions) .. I need to remove the data which is common in both columns.

```
Actual : 

    V1 V2 V3
   foo bar Car
   bar car man
  chain chain chain

Expected : 
    V1 V2 V3
   foo bar Car
   bar car man

```

If i filtered out V3.. i should have comparison with V1 and V2

```
V1 V2  
   foo car      

```

Any script painless in aggregation.. will help @Badger

---

<div class="post-metadata">

**Author:** ![christophilus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christophilus/32/42991_2.png) [@christophilus](https://discuss.elastic.co/u/christophilus)\
**Post date:** [May 3, 2019, 5:45pm UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/2 "2019-05-03T17:45:08Z")

</div>

I don't think this is possible given the current table visualizations. But it should be possible using Canvas: [https://www.elastic.co/guide/en/kibana/current/canvas.html](https://www.elastic.co/guide/en/kibana/current/canvas.html)

With Canvas, you can fetch data, and then do additional processing on it via a scripting language before displaying it as a table (or whatever visualization you choose).

---

<div class="post-metadata">

**Author:** ![TEJASWI\_CHUNDURI](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tejaswi_chunduri/32/46271_2.png) [@TEJASWI\_CHUNDURI](https://discuss.elastic.co/u/TEJASWI_CHUNDURI)\
**Post date:** [May 6, 2019, 10:18am UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/3 "2019-05-06T10:18:16Z")

</div>

Is there any work around

---

<div class="post-metadata">

**Author:** ![christophilus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christophilus/32/42991_2.png) [@christophilus](https://discuss.elastic.co/u/christophilus)\
**Post date:** [May 8, 2019, 2:31pm UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/4 "2019-05-08T14:31:54Z")

</div>

The best workaround I can think of is to write it in Canvas or in Vega. Both Canvas and Vega allow you to write your own queries. Canvas, in particular, allows you to also manipulate data in a scripting language. I think you could make that work.

---

<div class="post-metadata">

**Author:** ![TEJASWI\_CHUNDURI](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tejaswi_chunduri/32/46271_2.png) [@TEJASWI\_CHUNDURI](https://discuss.elastic.co/u/TEJASWI_CHUNDURI)\
**Post date:** [May 21, 2019, 10:20am UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/5 "2019-05-21T10:20:38Z")

</div>

I tried with Canvas, but not worthy . Where some limitation with canvas

> [@Canvas : is it possible to send varaibles to esql, edocs query argument or is it a limitation in canvas](https://discuss.elastic.co/t/canvas-is-it-possible-to-send-varaibles-to-esql-edocs-query-argument-or-is-it-a-limitation-in-canvas/181524):
>
> Will canvas support to pass the dropdown control values as variables to esql, esdocs query filters | esdocs index="appscan\*" fields="url\_type\_uniqref.keyword, fversion.keyword" query="version :$var"

---

<div class="post-metadata">

**Author:** ![TEJASWI\_CHUNDURI](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tejaswi_chunduri/32/46271_2.png) [@TEJASWI\_CHUNDURI](https://discuss.elastic.co/u/TEJASWI_CHUNDURI)\
**Post date:** [May 30, 2019, 12:45pm UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/6 "2019-05-30T12:45:10Z")

</div>

Hi christophilus , i got a way with bucket( selector) aggregations. How can i do that aggregation to work with visualisation

---

<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:** [June 27, 2019, 12:45pm UTC](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317/7 "2019-06-27T12:45:11Z")

</div>

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