Dataset

Nintex Bot can open, import, and process data from a data set A file that contains tabulated data for use in a botflow run. . Nintex Bot orchestrations allows you to use multiple bots to help process large datasets at a reduced processing time.

You can use datasets for bank conversions and acquisitions, loan portfolio acquisitions, large insurance files, and more. Simply build a botflow in Nintex Bot, import a dataset, and then configure the botflow in Nintex RPA Central. See the Instances Details page in Nintex RPA Central to view more information about your dataset records.

Only comma-delimited files (*.csv) are currently supported. The maximum file size allowed for the .csv file is 80 MB (for example, 550,000 rows and 17 columns).

Important: If your .csv file contains column or field titles that contain commas, you may receive an error message, "Names do not match." Do not use commas in field names. In Nintex Bot 17.2.0 and above, dataset field names can include commas. If you include a comma in a dataset field, ensure that the entire field is enclosed in double quotes (") so that Nintex Bot interprets the field as one field and not separate fields.

  1. From the menu bar, click Data > Open Dataset.
  2. Select a dataset file (.csv) and click Open.

  3. Enter your required fields and settings.

    Section Field or button Description
    Data Source File Displays the file path location of the dataset that was imported.
    Records

    Displays the number of items listed in the dataset file that was imported.
    Template (Optional) Type a template file name or click the ellipses to select a template file.
    Delimiter

    Select the required delimiter for the file.

    • Comma: Inserts a comma delimiter.

    • Pipe: Inserts a pipe delimiter.

    • Semicolon: Inserts a semicolon delimiter.

    • Space: Inserts a space as a delimiter.

    • Tab: Inserts a tab as a delimiter.

    • Other: Type a delimiter character or use the Expression Builder to build the action settings using variable or other token values.

    • None

    Parsing Definitions Start

    • Beginning: Begins the import from the beginning of the selected data file.

    • Exact Row: Begins the import from the exact row specified in the selected data file.
    End

    • End: Ends the import at the end of the selected data file.

    • Exact Row: Ends the import at the end of an exact row specified in the selected data file.

    • End Excluding: Imports the selected data file excluding specified rows.
    Use included field names Select to use included field names. Only displays when the data source file has field names.
    Fields   Select available fields to import.
    Import Template Creation Import Template (Optional) Type a template file name or click the disk icon to select a template file.
      Next/Cancel/Previous Click Next to proceed to the next page of the Data Wizard or click Cancel to discard any changes. Click Previous to go back to the previous screen.

  4. Click Done.

  5. Save the botflow.

    You're ready to configure and publish the botflow. See Botflows through Botflows

Note: If you add a dataset to a botflow in the Botflow pane or from the Data menu, and then later change your mind and use Data from the pane or menu, the dataset will not be removed from the botflow definition. When you publish the botflow, it will still require you to specify a dataset to use. To remove the dataset from the botflow in Nintex Bot, click Data > Clear Dataset Schema (the Clear Dataset Schema menu option is only enabled if a dataset is found).