What are differences between Append and merge

Question

Accepted Answer

Append adds new data to the end of a dataset, while merge combines two datasets based on a common key.

Append adds rows to the end of a dataset, while merge combines rows from two datasets based on a common key column.
Append is useful for adding new observations to an existing dataset, while merge is used to combine datasets with related information.
Append does not require a common key, while merge requires a common key to match rows from both datasets.
Example: Appending a new customer's information to a customer database vs. merging sales data with customer information based on customer ID.

Top EXL Service Assistant Consulting Manager interview questions & answers