π The Table and List Toolbox Is Fuller
New table and list components help you compare data, clean it up, and reshape it for the next step.
Tables and lists often need work before theyβre ready to use. You may need to find what doesnβt match, replace values from a lookup, fix column names and types, or flatten nested data from an API. These components cover those steps, so you can reach a clean result without building long chains of workarounds.
They fit tasks like comparing orders against stock, merging columns, and preparing an API list for a table.
New components
Table Operations
Diff Tables: Finds rows in the second table that do not have matching rows in the first table based on specified column names.
Find and Replace: Finds matching rows in the target table based on search columns and replaces values in the source table with values from the replace column.
Merge Columns: Merges two or more columns by concatenating their values in writing order.
Rename Column: Renames a column in the table.
Reorder Columns: Moves a column to a new position in the table. Other columns will be shifted as needed.
Change Column Types: Changes the types of multiple columns in the table schema.
Get Headers: Gets all column headers from the table as a List of Text values.
List Operations
Extract Nested List: Pulls a nested list out of your data so you can work with it directly.
Flatten List Fields: Turns nested fields in a list into a flat list.