To achieve the result shown in Figure B, which option must you use to update the data?

You imported a transaction data file into an empty model with the results as shown in Figure A. Later, a member of the finance team wants you to import a new data file. In the new data file, you find the following differences: The value of the Labor account has increased to 1600. There is a new record for the Services account, with a value of 250. The record for the Travel account has been deleted.

To achieve the result shown in Figure B, which option must you use to update the data?

A. Clean and replace selected version data

B. Append: Reject duplicated rows in model

C. Clean and replace subset of data with Scope = Version and Account

D. Update

View Answer

Answer: D