How to Evaluate a field from the list of another search and create a table

[manorajk]

There are two queries

`query 1` will give ID, TIME fields

`query 2` will give list of SPECIAL_ID

I want to create a table with TIME, ID, IS_SPECIAL_ID

IS_SPECIAL_ID is evaluated to true/false based on the condition where is ID is part of the list SPECIAL_ID

[manorajk]

@ITWhisperer Really appreciate your help here.

[ITWhisperer · Accepted solution]

Simplistically, you could do something like this

`query 1`
| join type=outer ID
  [search `query 2`
   | dedup SPECIAL_ID
   | rename SPECIAL_ID as ID
   | eval IS_SPECIAL_ID="true"]
| fillnull value="false" IS_SPECIAL_ID

However, as has been mentioned in numerous posts, using join and subsearches is not  always best practice due to the limitations of subsearches, but if the above suffices, it is a simple approach.