A data analyst is performing a data merge within a spreadsheet using the tables below:
The analyst is attempting to pull the addresses from Table 2 into Table 1 using the last names and is receiving an error message. Which of the following steps can the analyst perform to fix the error?

Question

A data analyst is performing a data merge within a spreadsheet using the tables below:

The analyst is attempting to pull the addresses from Table 2 into Table 1 using the last names and is receiving an error message. Which of the following steps can the analyst perform to fix the error?

Johan Wu · Accepted Answer

Review the spelling and data type.

Johan Wu · Answer

Use concatenate to combine the tables.

Johan Wu · Answer

Ensure the formula is pulling from right to left.

Johan Wu · Answer

Sort the data by the last name field.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 232 - DA0-001 discussion

Suggested answer: D

0 comments