Data Record Loop
Last updated
Last updated
Data Record Loop
is a that allows you to iterate over all the retrieved, after a successful read operation, by the , and blocks.
NOTE: This block will provide valid values only after the , and blocks complete their execution. The block can be used to track the completion.
The block consists of the following (from top to bottom):
Here is a summary of the above example:
Table: that accepts a value representing the name of the .
Dataset Name: that accepts a value representing the name of the dataset on which a database read was conducted using the , and blocks.
Tasks: a where you connect blocks that specify what you want done with each record. Use the and blocks here to access the record information for each iteration.
NOTE: Please refer to the prerequisite information shown before seeing the example.
The image below shows an example of the Data Record Loop
block. This example incorporates the Usage Example function, as outlined in the on the prerequisite information page mentioned above.
The Data Record Loop
block is used with the Customers and the dataset name of ds1 are as .
For each iteration inside the Tasks , we use the block to log the customer's full name by accessing the FirstName and LastName fields of each record and combining them.
To access information about the record, we use the block.
For the FirstName and LastName fields we use the block.
The result for the above example can be seen in the , and a sample is shown below: