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.

Image showing the intersection of two datasets, using the readfile() function as the primary query

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:

logscale
readFile("host_names.csv")
| !join(query={groupBy(host_name)}, field=host_name, key=host_name, include=[host_name, id])