LOOKUP

LOOKUP is used to get the row data corresponding to dataset name from Drag and Drop DB (DDDB).
Edited by: Ayush

• To get the values from DDDB

This command will search for primary key 'mykey' in dataset 'demo_dataset'. Data corresponding to the primary key will be shown in the result , all the keys received from database will start with “lookup_”.

• DO NOT USE in the root node.
• Use database name which is already present in the system.

LOOKUP command is for node level operations. It can be used in any node as an instruction, except for the root node. It should not be used on the Arrows.

Let's take an example: LOOKUP 'weekly_diesel_price' 'eia_gov'
Here, 'eia_gov' is the primary key, and 'weekly_diesel_price' is the name of the dataset, and the command would return all the columns of respective primary key.
If you had a tree variable "$key" which was previously initialized to "eia_gov", the above command could also have been LOOKUP 'weekly_diesel_price' $key