You can select the DataTable you want to modify as well as the one you want to save changes in, from the following fields: It can be opened by using the Filter Wizard button in the body of the activity in the Designer panel. This wizard helps build the filtering options for a DataTable variable. Excel ranges are not supported as input for this activity.If you copy and paste a customized Filter Data Table activity inside the Designer panel, it does not retain its configuration.This field supports only DataTable variables. Using the same variable as the one in the Input field overwrites the initial variable, while adding a new variable leaves the initial one unaffected. DataTable - The resulting filtered DataTable variable.SelectColumnsMode - Specifies whether to filter the table by keeping or removing the target columns.
FilterRowsMode - Specifies whether to filter the table by keeping or removing the target rows.Private - If selected, the values of variables and arguments are no longer logged at Verbose level.DataTable - The DataTable variable that you want to filter.DisplayName - The display name of the activity.📘ĭue to internal changes, this activity will no longer be visible in the Favorites list when upgrading to v20.4 or newer, if it was added to the Favorites list with a v19.4 or older version of. The body of the activity contains a Filter Wizard button so that you can access the wizard and customize your settings at any time. The activity can keep or delete rows or columns according to the logical conditions that are specified in the wizard. DescriptionĮnables you to filter a DataTable variable by specifying conditions in the Filter Wizard window.
0 kommentar(er)
