Hello I have a search which is gathering 8 columns from a table. (below) I want to make col1 available to query against later in the SPL. I tried to access via "rename query.col1 as col1" for example but the data does not seem to appear, almost as if query.col1 is not valid? Can't find any info on how to remedy this elsewhere on the site, apologies if this has been asked before. The query returns 1 row.             | dbxquery query="Select col1,col2,col3,col4,col5,col6,col7,col8 from JuiceTable where col1 = 'special value'" connection="Juice-Prod" | stats count as total | eval Status=case(total=0,"Healthy",total > 0, "Critical")             ... View more