(all outputs are based on Example database)

Importing Example database

Download the csv sources

Go to the Forge, open or create the mission with the network.

Open Data Explorer application

image.png

Create a new database with the name Example, set the asset name db_example

image.png

Import the first csv, for example, Stores. Pay attention, the table name must be the same as the file name (without extension). This is important for correct example query outcomes.

image.png

Your result should look like this. Don't forget to save the database to the network asset storage by clicking Apply Changes button.

image.png

search

Add a row to the result table if any cell in this row contains the defined value (case-insensitive search is used). This can be the first element in the pipeline. If it is the first element, all tables will be checked (the query will be executed against the entire database).