I've been trying to join the results of a search with a dataset on one line. I can get it to work with two lines, but it's hard to read and doesn't work with more than one result. I just want to combine the file_1 data with the search results. Here's what I have: index=windows [| inputlookup file_1 | fields field1] | dedup field1 | table field2, field3, field4 | append [| inputlookup file_1] Output First Line: field2 field3 field 4 Second Line: field1 field 5 etc I'd like it to be on one line. field1 is common to both the search and the dataset. Thanks in advance
... View more