Using the readFile()
Function
The readFile()
function reads a file that has
previously been loaded into LogScale using
Uploading a File or an automated
method. The function could also read tables defined with the
defineTable()
function.
When used, the readFile()
function can operate as
dataset to help seed or join with other data in the form of a primary
query as part of a right
join, using the defined file, or table, as the input source for
the data set.
readFile()
is used with the
join()
function to match information. For example,
the query below uses a lookup file as the basis of the query to select a
base set of hostnames touse when querying access data:
readFile("host_names.csv")
| !join(query={groupBy(host_name)}, field=host_name, key=host_name, include=[host_name, id])