I have a dataset 1 like: VID A212 A213 B151 B153 Dataset 2 like: QID Solution 2145 text contains A212 2155 text contains B151 2157 text contains A212 2855 text contains B151 Wanted output like: VID QID Solution -> for all matching cases I tried the following search for a single item search and it is working fine |from inputlookup:"dataset1" |where like(vid,"%A212%")|stats values(vid) as vid |map [|from inputlookup:"dataset2" |where like(Solution,"%".$vid$."%") |Table QID,Solution] But when the main search returns multiple values, it is not working - shows no results. |from inputlookup:"dataset1" |where like(vid,"%A%")|stats values(vid) as vid |map [|from inputlookup:"dataset2" |where like(Solution,"%".$vid$."%") |Table QID,Solution] What am i doing wrong here ? ... View more