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, remove rows that contain null values, and name the query. Select Next and your data is now ready for unification.
Does this meet the goal?
Transforming the first row to be used as headers, removing rows with null values, and naming the query prepares the data appropriately for unification in Customer Insights - Data.
By setting the headers and removing rows with high proportions of nulls, the data becomes cleaner and more structured, which is essential for successful unification in Customer Insights. Therefore, this solution meets the goal of preparing the data for unification.

