Using the readFile()
Function
The readFile()
function reads a file that has
previously been loaded into LogScale using
Uploading Files 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 following query uses a lookup file as the basis of the query to
select a base set of hostnames to use when querying access data:
readFile("host_names.csv")
| !join(query={groupBy(host_name)}, field=host_name, key=host_name, include=[host_name, id])