createAggregationsOnDataFile (Array Creation & Manipulation)
Compatible with:
- Purpose
- This command allows you to perform aggregations on Data Files and get the results stored into a new target Dataset that is passed into the target field of the instruction.
The Dataset used in target field has to be created anywhere in run time before this command gets executed. Else, the test run gets aborted saying "For one or more Instructions within the Test Script "<Test Script name>" that use the "<Array Creation & Manipulation Command>" command, the Dataset name provided in the 'Target' field does NOT exist in the scope of the Test Scenario" message. - The Datafile on which the aggregation is performed should be mentioned in the 'FROM' clause of the query string (see below).
SELECT Column1, Column2, mean(Column3), sum(Column4)
FROM <datafile(status)>
GROUP BY Column1, Column2
If there are more than one datafiles is used in the aggregationQueryString, the list of data files that are used in the aggregationQueryString should be mentioned separately in Value field separated by "||" symbol.
SELECT d1.Column1, d2.FirstColumn FROM DataFile1(W) d1 inner join DataFile2(W) d2 on (d1.Column1=d2.Month)||DataFile1(W),DataFile2(W)
If datafile status is not given. by default, it will be considered as Active.
This sort of command will help us create summaries that they can be either attached to emails or printed into the email body of emails that get sent from the test run context.
- Syntax
- createAggregationsOnDataset(datasetName,aggregationQueryString)
- Target
- datasetName
- Value
- aggregationQueryString( comma separated values in case of multiple labels)
- Return Value
- N/A