The Query block enables you to create SQL code that you can use to join database tables or datasets, to get specific data from one or more database tables or datasets.
The following demonstrates how to use the Query block to select rows from the input dataset lib_books.csv (which contains observations that describe a range of books available from a lending library) that contain the title of a book by a particular author that is no longer in the library.
author EQ "Rendell, Ruth" AND In_Stock EQ "n"This specifies that only those rows where the Author column contains the text Rendell, Ruth and the In_Stock column contains n, are output to the working dataset.
A green execution status is displayed in the Output ports of the Query block and the new Working Dataset. The dataset contains the books written by Ruth Rendell that are no longer in the library collection.