(all outputs are based on Example database)
Download the csv sources
Go to the Forge, open or create the mission with the network.
Open Data Explorer application
Create a new database with the name Example
, set the asset name db_example
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.
Your result should look like this. Don't forget to save the database to the network asset storage by clicking Apply Changes
button.
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).