subsearch for multiple indexes

[anudeep247]

Hi All

I have 2 indexes. 1st indexes contains list of names. i have to pass each name as input to second index and calculate values for each name.

We can use two quires to get each name and pass to 2nd index. But i need them in single query. expecting output fields from 1st index as well as calculated fields from the 2nd index.. ?????

[somesoni2]

If name is the common field in both indexes, you can use below to get all attributes for a name from two indexes.

index=indexA | table name,..other fields from indexA... | join name [search index=indexB | table name,..other fields from indexB...]

[somesoni2]

I believe so. Let me know if there are any issues.

[anudeep247]

Thank you somesoni2,
Here name is common for both indexes and i also have 2nd fields with different name. will this work??