# How to build multi index relation? **URL:** \ **Category:** Elasticsearch\ **Created:** [March 28, 2014, 3:15pm UTC](https://discuss.elastic.co/t/how-to-build-multi-index-relation/16682 "2014-03-28T15:15:38Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Nick\_Chang\_2](https://avatars.discourse-cdn.com/v4/letter/n/7c8e57/32.png) [@Nick\_Chang\_2](https://discuss.elastic.co/u/Nick_Chang_2)\ **Post date:** [March 28, 2014, 3:15pm UTC](https://discuss.elastic.co/t/how-to-build-multi-index-relation/16682/1 "2014-03-28T15:15:38Z")
Hello All I have multi index from different input. Ex: One of MongoDB : One of MySQL ; One of Accesslog. User information in the MySQL. User Behavior in ther Mongodb. IP in the accesslog. User information include "User account", "book name", "book id" User Behavior include "book id", what is user's device( iPad or iPhone or Android device .... etc ) I want to Analysis user behavior, then output to report for Other PM. But I can't change book id to book name. I have saw has\_parent and has\_child. I don't know this fuction can do it??? Please give me a suggestion. Thanks -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/3a629ca0-2751-46d8-ab7a-e99e88d58d2e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/3a629ca0-2751-46d8-ab7a-e99e88d58d2e%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:39am UTC](https://discuss.elastic.co/t/how-to-build-multi-index-relation/16682/2 "2017-07-06T01:39:51Z")
Closed on July 6, 2017, 1:39am UTC