AWS quicksuite documentation change
Summary
Completely restructured and expanded documentation for data table actions, replacing brief bullet points with detailed sections for each action including properties, parameters, examples, and usage instructions.
Security assessment
The changes are purely functional documentation improvements with no references to security vulnerabilities, patches, or security-specific features. The additions focus on general data manipulation capabilities without addressing authentication, authorization, data protection, or vulnerability mitigation.
Diff
diff --git a/quicksuite/latest/userguide/actions-data-tables.md b/quicksuite/latest/userguide/actions-data-tables.md index a82aa7ecf..3ad805912 100644 --- a//quicksuite/latest/userguide/actions-data-tables.md +++ b//quicksuite/latest/userguide/actions-data-tables.md @@ -4,0 +5,2 @@ +Sort TableFilter TableLookup ValueAdd ColumnsRemove ColumnsKeep ColumnsAdd New RowRemove RowsRemove DuplicatesAppend TablesCreate New TableConvert Text to TableConvert Table to HTMLExamples + @@ -7 +9,221 @@ - * **Sort table** \- Orders a table by a column. Used to organize your data in ascending or descending order. +Data table actions enable you to work with structured data in table format. These actions allow you to create, transform, and output tabular data in your automations. + +## Sort Table + +Orders a table by a column. Used to organize your data in ascending or descending order. + +**Properties:** + + * **Data Table** (required): The table variable to sort (e.g., `my_table`) + + * **Column Name to Sort** (required): Name of the column to sort by (e.g., "Total amount") + + * **Sort Order** (dropdown): Choose "Ascending" (smallest first) or "Descending" (largest first) - default: Descending + + * **Sorted Table** (output): Variable name for the new sorted table + + + + +## Filter Table + +Keeps rows matching a criteria. Used to extract relevant rows from a larger data set. + +**Properties:** + + * **Data Table** (required): The table variable to filter (e.g., `my_table`) + + * **Filter Expression** (required): Boolean expression using column names and operators (==, >, <, !=). Combine conditions with & (AND) or | (OR). Use single quotes for column names with spaces and text values (e.g., "'Team' == 'Sales' & 'Total amount' > 100") + + * **Filtered Table** (output): Variable name for the filtered table + + + + +Example filters: + + + # Column 'amount' is greater than 25 + "amount > 25" + + # Column 'team' equals text 'Sales' + "team == 'Sales'" + + # Multiple conditions + "amount > 25 & status == 'active'" + + # Grouped conditions + "(amount > 25 & team == 'Sales') | (amount > 50 & team == 'Marketing')" + + # Column 'title' contains text 'Director' + "title.str.contains('Director')" + + # Column 'start_date' is less than '2024-02-02' + "start_date < '2024-02-02'" + +## Lookup Value + +Searches a value in a table. Used to lookup a value in one column and get the corresponding value from another column in the same row. + +**Properties:** + + * **Data Table** (required): The table to search in (e.g., `my_table`) + + * **Column Name to Search** (required): Column containing the lookup value (e.g., "Employee ID") + + * **Value to Search For** (required): The value to find (e.g., "12345") + + * **Column Name to Output** (required): Column to retrieve the result from (e.g., "Date of hire") + + * **Cell Value** (output): Variable storing the found value. Returns first match or empty if not found. + + + + +## Add Columns + +Creates new columns in a table. Newly added columns are appended to the end of the existing table. + +**Properties:** + + * **Data Table** (required): The table to modify (e.g., `my_table`) + + * **Column Names to Add** (required): Array of new column names (e.g., ["Name", "Address"]) + + * **Default Value** (optional): Initial value for all cells in new columns (e.g., "N/A") + + * **Updated Table** (output): Variable name for the modified table + + + + +## Remove Columns + +Deletes columns from a table. Outputs a table with all of the remaining columns. + +**Properties:** + + * **Data Table** (required): The table to modify (e.g., `my_table`) + + * **Columns to Remove** (required): Array of column names or index numbers. Index numbers start at 0 and can be specific numbers (e.g., [0,1,2]) or ranges (e.g., range(0,2)) + + * **Updated Table** (output): Variable name for the modified table + + + + +## Keep Columns + +Drops extra columns from a table. Used to select a specific subset of columns you want to keep. + +**Properties:** + + * **Data Table** (required): The table to modify (e.g., `my_table`) + + * **Columns to Keep** (required): Array of column names to retain (e.g., ["Name", "Address"]) + + * **Updated Table** (output): Variable name for the modified table + + + + +## Add New Row + +Appends a new row to a table. The new row can be created with specific values or as a blank row and will be added to the bottom of the table. + +**Properties:** + + * **Data Table** (required): The table to modify (e.g., `my_table`) + + * **Row Values** (optional): Array of values for the new row, starting from the first column (e.g., ["Q1", "Sales", 100]). If empty, adds a blank row. Missing values result in blank cells. + + * **Updated Table** (output): Variable name for the modified table + + + + +## Remove Rows + +Deletes rows from a table. Outputs a table with all of the remaining rows. + +**Properties:** + + * **Data Table** (required): The table to modify (e.g., `my_table`) + + * **Rows to Remove** (required): Array of row positions (0-based indexing). Index numbers start at 0 and can be specific numbers (e.g., [0,1,2]) or ranges (e.g., range(0,2)) + + * **Updated Table** (output): Variable name for the modified table + + + + +## Remove Duplicates + +Deletes duplicate rows. Used to create a dataset of unique rows based on specific columns. + +**Properties:** + + * **Data Table** (required): The table to clean (e.g., `my_table`) + + * **Columns to Check** (optional): Array of column names for duplicate detection (e.g., ["Name", "Address"]). If empty, checks entire rows for uniqueness. Duplicates are identified by combined values across specified columns. + + * **Duplicate Row to Keep** (dropdown): Choose "First" or "Last" occurrence to retain (default: First) + + * **Updated Table** (output): Variable name for the modified table + + + + +## Append Tables + +Combines the rows of two tables. Used to add data from one table to another. + +**Properties:** + + * **Table to Append To** (required): Main table receiving additional rows (e.g., `main_table`) + + * **Table to Add** (required): Source table providing rows to append (e.g., `new_data`) + + * **Handle Column Differences** (dropdown): + + * "Add": Keep all columns from both tables + + * "Ignore": Only keep columns matching the primary table + + * "Error": Require exact column matches + + * **Combined Table** (output): Variable name for the merged table + + + +