Extract Row

You can extract data based on rows from the Recorder View when executing the Email step or the Database group of steps. Ensure that a complex type is created with attribute names and types that correspond to the table columns, and either the attribute name or the storage name matches the column name.

When you execute the Email step or any of the Database-related step, you can navigate to the necessary row of the opened table in the Recorder View. Click the square indicator to the left of the necessary row to check, whether the column types match the complex type created for the extraction of the row. Edit the type if needed.

Extract All Columns

You can extract the data from all of the columns of the row by right-clicking the square indicator to the left of the row and selecting Extract Row > All Columns Into > extr: <Complex type name>. For each cell, an Extract Data step appears in the Robot workflow. You can configure the extracted data and assign variables to the appropriate types.

Extract Matching Columns

To extract the data from the columns that match only the attribute name and its type, right-click the indicator to the left of the row and select Extract Row > Matching Columns Into > extr: <Complex type name >. In the Robot workflow, you can see the number of Extract Data steps equal to the number of the cells that match the chosen complex type. Edit and configure the data and proceed to the next step of the Robot workflow.