Which transformation would you use to combine rows from multiple datasets into one?

The appropriate transformation for combining rows from multiple datasets into one is known as Union. When utilizing Union, you can effectively stack datasets vertically so that the records from one dataset follow those from another, as long as both datasets have the same number of columns and compatible data types. This is commonly used in data analytics to consolidate data from different sources, allowing for a comprehensive analysis of the combined records.

While terms like Append or Merge might seem relevant, they have different implications. Append generally refers to adding new records to an existing dataset without fundamentally changing its structure. Merge typically refers to combining datasets based on a common key or field, which aligns more with horizontal combinations rather than vertical stacking. Therefore, Union is the transformation that correctly conveys the action of combining rows from multiple datasets into a single dataset.