Join Methods

LogScale supports multiple methods for performing joins or lookups on data:

Method Left Join Inner Join Right Join Repository Join
defineTable() Yes Yes Yes Yes
readFile() No No Yes Indirect
match() Yes Yes No Indirect
join() Yes Yes No Yes
selfJoin() Yes Yes No No
  • Using Ad-hoc Tables with defineTable()

    The defineTable() enables you to create a table based on a query that can then be used with other functions as the primary or sub query.

    For more information, see Using Ad-hoc Tables and the defineTable() function.

  • Using readFile()

    The readFile() function can be used to perform a join by providing the dataset that will be used as the primary key for the query.

    When using readFile(), the data contained within the file acts as the primary query. Data can be joined to the result set using a left or inner join.

    For more information, see Using the readFile() Function and the readFile() function.

  • Using match()

    The match() function matches data from the primary query with a file that contains static lookup information.

    For more information, see Using the match() Function and the match() function.

  • Using the join() Function Single Repository

    The join() performs a left or inner join on two LogScale queries, the primary query and a sub-query. The queries can be on the same repository and can be either a left or inner join by setting the mode.

    For more information, see Using the join() Function and the join() function.

  • Using the join() Across Repositories

    The join() can be used to join data across repositories. When used in this form, the primary query is executed against the current repository and the sub-query against the repository specified in the repo parameter to the function.

    For more information, see Joining Two Repositories and the join() function.

  • Using selfJoin()

    The selfJoin() collates data together within a repository where the data being collated shares the same value.

    For more information, see Using the selfJoin() Function and the selfJoin() function.