Thanks @gcusello for the quick response. Apologies for the confusion. To your question :- No, My macro contains nothing but the lookup and some filtering which produces the results as follows indexes
index IN ("ABC","DEF") Now I wanted to use the macro's results as a subsearch. Now, I cannot use the lookup directly as I have too many indexes. All I wanted to take into account for the subsearch is just as below index IN ("ABC","DEF") but for now as I have a column name as indexes I am getting the subsearch as below which ending up with an error indexes=index IN ("ABC","DEF") Now, is there any way to tweak my subsearch or macro take the below into account which will work? index IN ("ABC","DEF") Where as my full search would be something like below after expanding the macro My_Search | where index IN ("ABC","DEF")
... View more