![]() ![]() Imagine that different data entry teams had typed the products’ release dates in five different formats:įor the sake of simplicity, assume that all the teams use the English/United States Locale in their regional settings, so the first date,, is July 1 (not January 7). This workbook contains the AdventureWorks product catalog, with the release date of each product in the last column. Exercise 2-5: Handling Multiple Date Formatsĭownload the workbook C02E05.xlsx from and save it in C:\Data\C02. Exercise 2-5 shows how Power Query handles a column with mixed date formats. Power Query automatically converted the Date column to Date/Time. In Exercise 2-4, you imported a dataset with a Date/Time column. When you load a table with dates or date/time values, Power Query converts the relevant columns to their correct date/time format. At the end of this section you will learn how to extract specific date or time elements from date/time values. You will start with a common challenge-converting text to dates-and then move on to more challenging cases involving invalid dates. In this section you will learn how to handle dates and times. While text columns are easy to handle, numbers and dates can make even the simplest datasets daunting for analysis. One of the most common data preparation challenges is dealing with data types.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |