Running a lookup where I have verified the fields exist and match and its not returning an output field. So, I verified by running the lookup by itself and it still doesn't match. I have checked permissions, ran the search from the app it belongs to. I can view the lookup with "| inputlookup <name>".   Example running the lookup on itself: | inputlookup myfile | table a, b | lookup myfile a OUTPUT b AS c | table a, b, c c always shows as empty for this one lookup ... View more

<dashboard> <search id="mySearch1"> <query>|makeresults </query> </search> <search id="mySearch2"> <query>* </query> </search> Goal: Need to make a table like: id query mySearch1 |makeresults mySearch2 * I tried using the spath command such as: | spath input=eai:data output=ID path=dashboard.search{@id} | spath input=eai:data output=query path=dashboard.search.query But this only gives me the first id (same if I don't specify a path) Then if I use the rex command to pull the id, I have 2 ids and 2 queries with no way to match which goes with which. Regular expressions for XML isn't a great idea to pull the whole <search id="searchID"> ... </search> tag into a field but the spath command isn't giving me that option. Any ideas? ... View more