# Connect two documents **URL:** \ **Category:** Kibana\ **Created:** [November 8, 2017, 8:15am UTC](https://discuss.elastic.co/t/connect-two-documents/106816 "2017-11-08T08:15:45Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![kumpelblase](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumpelblase/32/35709_2.png) [@kumpelblase](https://discuss.elastic.co/u/kumpelblase)\ **Post date:** [November 8, 2017, 8:15am UTC](https://discuss.elastic.co/t/connect-two-documents/106816/1 "2017-11-08T08:15:45Z")
I have an Index with two types: ticket and status. In a document of the type ticket are fields like TTS\_Status which can be 1 to 6. A status document only has two fields: STS\_Number and STS\_Term, which could look like this: {"STS\_Number":1, "STS\_Term":"New"}. If I create a pie chart, I want to relpace the number from TTS\_Status with the matching String in STS\_Term, by joining them with STS\_Number. ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [November 8, 2017, 3:13pm UTC](https://discuss.elastic.co/t/connect-two-documents/106816/2 "2017-11-08T15:13:04Z")
There is no way of doing that in Kibana other than flattening the documents and including the child one in the parent document. There is an open enhancement request here: [https://github.com/elastic/kibana/issues/1084](https://github.com/elastic/kibana/issues/1084) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 6, 2017, 3:13pm UTC](https://discuss.elastic.co/t/connect-two-documents/106816/3 "2017-12-06T15:13:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.