A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below:

Which of the following steps should the analyst take to create the table?

Question

A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below:

Which of the following steps should the analyst take to create the table?

Accepted Answer

D. Create a column that concatenates the first name and last name in each table. Use concatenate Creating a concatenated column of first name and last name in each table establishes a unique identifier for each employee. This composite key can then be used in a lookup or join operation to accurately combine sales and address information from different tables into a single comprehensive table.

Answer

A. Transpose the first name and last name in both tables. Use lookup to pull the address field from Transposing first and last names changes their orientation, which is not relevant for combining data based on matching employee records.

Answer

B. Use lookup with the first name or first name to pull the address field from Table 2 into Table 1. Using lookup with only the first name or only the last name is risky and can lead to incorrect matches if multiple employees share the same first or last name.

Answer

C. Use the append formula in both tables for the first name and last name. Use lookup to pull the Appending first names and last names into existing columns in both tables does not create a single, reliable join key and is not a standard way to combine related data from separate tables.

A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below: Which of the following…

Question

Exhibit

Options

How the community answered

Why each option

Topics

Community Discussion