There are many tools available in EASA to process and manipulate data, data may be entered by a User or read from an outside source, such as a database, spreadsheet or text file.
DATA PROCESSING is a parent for SCALAR and LIST data processing objects.
A SCALAR contains a single value, while a LIST is a sequence of one or more values.
1. Login in, select Stock Screener and open it in the EASAP Builder.
2. A DATA PROCESSING > COMPUTE is an expression that evaluates to a value.
Here we want to know if the User has changed the default blank setting for the stock exchange INPUTBOX.
3. We use a logical expression to signal if the User has chosen to filter by stock exchange.
Value: will evaluate to either:
4. Create a similar COMPUTE for inputbox_Sector, to signal that a User has changed the 'business sector' INPUTBOX.
5. Create a third COMPUTE for inputbox_Field_Name
1. Add a MAP to store a partial WHERE-clause for a SQL query to narrow a results set.
This MAP takes a current value of compute_Exchange of possible Inputs: and sets map_Exchange to the corresponding value of Outputs:
An reference to map_Exchange will be used in the SQL statement as described in Session 5
2. Copy and Paste the MAP in the prior step and modify it for the 'business sector' part of the SQL query.
3. Copy and Paste a third MAP, then combine the two earlier MAP's into a completed SQL query.
EXPAND constructs one or more lines of text.
1. The financial query can be composed directly from the three INPUTBOXs for use in the REPORT.
2 . Use a MAP to insert either a blank space or the financial query if it is selected, into the REPORT (see Session 7).
3. Confirm the EASAP Tree looks similar to the following.
We have completed Session 4 and we may either proceed to the next session or take a break and exit out of EASAP Builder.