A company's IT department has a .CSV file stored on one of their Shared Documents folders within their Microsoft SharePoint sites. The data from the .CSV file is ingested into Dynamics 365 Customer Insights - Data.

The file contains a row header and columns of different types, such as quantities and prices. The file also contains some rows with a high proportion of nulls.

You need to clean and transform the data in Customer Insights - Data to be ready for unification.

Solution: Transform the first row to be used as headers. Define column types to be appropriate field types and name the query. Create a full name and full address columns by merging the appropriate columns if they exist. Select Next and your data is now ready for unification.

Does this meet the goal?