what is the difference lookup ,join ,merge

Question

Accepted Answer

Lookup is used to search for a specific value in a dataset, join is used to combine two datasets based on a common key, and merge is used to combine datasets based on common columns.

Lookup is used to find a specific value in a dataset
Join is used to combine two datasets based on a common key
Merge is used to combine datasets based on common columns
Example: Lookup - searching for a customer's email address in a customer dataset
Example: Join - combining sales data with customer data based on customer ID
Example: Merge - combining two datasets with common columns like date or product ID

what is the difference lookup ,join ,merge

Top HR questions asked in NTT Data Senior Business Intelligence Specialist