Lookup Data for Automation and Tests from Lists
In this video we illustrate how to lookup data from a list and inject it into fields within Test Modeller.
Create a List
To create a list, navigate to the Master Data Management section and select Data Dictionary. In the Data Dictionary menus there is a tab called ‘Lists’ where you can create, manage, and view all lists.
To create a new list, click the ‘New List’ button in the top right. To edit an existing list, first search for it using the filter option, then you can open it by clicking on the name of the list.
Fill out the form with the relevant information.
Name - Give the list a name
Application - Select the registered application that the list is relevant to
Description - Give the list a description
External Provider - Select if the list should be automatically imported from an external provider
Provider Type - allows you to select where the data to be imported is coming from.
Data Sheet: Here, you select the data sheet you want from inside Test Modeller.
SQL: Here, you select a SQL server database that you have already defined in your workspace. It comes with the usual querying options you would expect with SQL.
VIP Flow: Here, you can select a VIP (RPA workflow engine) flow to load the data into a list.
Use as Category - Select if the list should be used as a category for Test Data Generation and Masking.
When the list is created without using an external provider, a list with one empty column is created. Rows, columns, and data can all be added manually if required. However, if you click the ‘Upload’ button this allows a csv file to be imported.
To append a list, the rows in the list must match the rows in the CSV. If replacing a list this doesn’t matter because the whole list will be replaced with the contents of the CSV.
Reference List from Model
To find the List Resolver, open a test data assignment and inside the left hand menu select the ‘LISTRESOLVE’ function. This will open the List Resolver wizard.
Find more information about how these work here. In the below example we are telling the resolver to only consider rows where the FirstName does not equal 'George'.
Used (Grouped) Columns
Imports and groups the columns that are used within the resolver. In the below example, the FirstName, LastName, and Email columns are grouped so that when the function resolves it will always return values for the three variables from one row in the list.
Column to Use
Allows you to specify the column that you want to fetch the data from; this will map to a test data variable inside the model.
Define which columns should return different values every time the function resolves.
Define which column should be used to order the data and if it should be ascending or descending.
Limits how many rows of data the resolver function will pick from. I.e if it is set to 5, then the resolver will only ever fetch values from the first 5 rows in the list, unless overriden by the next field, ‘Start Offset’.
Offsets the resolver by specifying on which row you want to start picking data from, this can be used in conjunction with Limit.
Whether you want to randomly pick rows from a list or start from the beginning.
Note that in the resolver function you will see ‘NotFound’ and ‘ResolveError’; these are used for logging.