Homepage | About EASA | Contact
Practical Session 3 | Practical Session 5
Estimated completion time = 10 minutes.
There are many tools available in EASA to process and manipulate data. The data to be processed can be data entered by users or data read from an outside source, like a database, spreadsheet or text file.
The object under which all the available data processing tools reside is DATA PROCESSING.
A DATA PROCESSING itself has no parameters. It is a Parent for SCALAR and LIST data and related processing.
A SCALAR contains a single value, while a LIST is a sequence of one or more values.
Please follow the instructions below to complete this practical session.
The first DATA PROCESSING we use is a COMPUTE. A COMPUTE is an expression that evaluates to a value.
The first data processing objects to create are compute objects that will store logical expressions that determine whether any filtering of data is performed when the stock data is read from the database.
Parameter Name | Parameter Value |
---|---|
Value: | inputbox_Exchange == "" (two empty double-quotes for empty string) |
Note: For the above expression the value will either equal 1.0 or 0.0 depending on if the expression is 'true' or 'false'. In step 7, you will use this compute_Exchange DOR (Delimited Object Reference) in a MAP.
Let’s create a similar COMPUTE for inputbox_Sector.
Parameter Name | Parameter Value |
---|---|
Value: | inputbox_Sector == "" (two empty double-quotes for empty string) |
Create a third COMPUTE for inputbox_Field_Name.
Parameter Name | Parameter Value |
---|---|
Value: | inputbox_Field_Name ==""(two empty double-quotes for empty string) |
Now we add a series of MAP's to store values to be used in the WHERE clause of the SQL query that will read the stock data from the database.
Parameter Name | Parameter Value |
---|---|
Value: | compute_Exchange |
Inputs: | 1.0,0.0 |
Outputs: | ,AND Exchange = '%inputbox_Exchange%' |
Note: The Outputs: parameter value has a space in front of the comma.
map_Exchange is a mapping that takes a particular value of compute_Exchange (the Inputs: field) and sets map_Exchange to a corresponding value (the Outputs: field).
The map_Exchange DOR will be used in the SQL statement as described in Practical Session 5
Right-click map_Exchange select Copy then Paste (Sibling). Rename it map_Sector and set:
Parameter Name | Parameter Value |
---|---|
Value: | compute_Sector |
Inputs: | 1.0,0.0 |
Outputs: | ,AND Sector = '%inputbox_Sector%' |
Note: The Outputs: parameter value has a space in front of the comma.
Parameter Name | Parameter Value |
---|---|
Value: | compute_Query |
Inputs: | 1.0,0.0 |
Outputs: | ,AND %inputbox_Field_Name% %inputbox_Operator% %inputbox_Value% |
Note: The Outputs: parameter value has a space in front of the comma.
Parameter Name | Parameter Value |
---|---|
Value: | %inputbox_Field_Name% %inputbox_Operator% %inputbox_Value% |
Note: The Value: parameter value has a space in-between the ‘%’ symbols.
EXPAND is used to define one or more lines of text. In the instance above, the EXPAND will take the value of the DORs located in the Value: parameter.
Parameter Name | Parameter Value |
---|---|
Value: | compute_Query |
Inputs: | 1.0,0.0 |
Outputs: | , %Financial_Query% ← intial <SPACE> on this line |
Your EASAP tree should look similar to the following:
You have now completed Practical Session 4 and you can either proceed to the next session or take a break and exit out of EASAP Builder.