To clarify a bit, let me give some additional info... I am creating a dashboard where I will show the top 3 users in 4 different environments, then I will run specific queries against each of those users. I can run 3 independent searches, one for each environment to produce the below and then tokenize them, using <set token="top_hit1">$result.first$</set>, etc. Search1 environment col1 col2 col3 col4 production top_user1 top_user2 top_user3 top_user4 Search2 environment col1 col2 col3 col4 non-production top_user1 top_user2 top_user3 top_user4 Search3 environment col1 col2 col3 col4 lab top_user1 top_user2 top_user3 top_user4 BUT, to make things a bit cleaner, I prefer to put this all in one table, and using appendcols and a transpose, produce a 3 row x 3 column stats table. environment col1 col2 col3 col4 production top_user1 top_user2 top_user3 top_user4 non-production top_user1 top_user2 top_user3 top_user4 lab top_user1 top_user2 top_user3 top_user4 I want to be able to tokenize each one individually so that I can, for example, run a query against the username who is lab top_user3. SO, i am not looking to join fields, but rather tokenize the values of a specific field. I would think it would be something that I would like $result.lab.col3$ but it is not 🤔
... View more