Refer to the exhibit.

The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States. The data architect must fix this issue in the LOAD script.

Which function should the data architect use to fix data quality issue?