I originally have two index patterns with one same item called user.id. Now I create one more index pattern which combines those two indexes. But I find that they just simply add one index after another, which includes two same user.id and doesn't satisfy my requirement.
I want to use user.id like a foreign key in SQL. After combination, I expect to get only one row with one user.id and all related information from the two indexes, and then show them in Kibana Data Table.
Are there any methods to achieve this goal?