# 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:** 1\
**Showing post:** 5

<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"

---

_[View the full topic](https://discuss.elastic.co/t/data-table-split-by-columns-need-to-remove-the-data-which-is-in-both-columns-exclude-that-data/179317)._