Power Query Tutorial: How to Split Columns by Delimiters скачать в хорошем качестве

Power Query Tutorial: How to Split Columns by Delimiters

This YouTube video is a comprehensive guide on how to split columns in Power Query by delimiter. The video covers several techniques that can be used to split columns, including the default delimiter, custom delimiter, digit to non-digit, non-digit to digit, extracting characters, and splitting columns into rows. The first technique covered is the default delimiter, which is the most commonly used method to split columns in Power Query. Next, the video shows how to split columns by a custom delimiter, allowing users to specify their own delimiter when splitting columns. The video also covers techniques for splitting columns based on whether they contain a digit or non-digit character. This can be useful for separating columns with mixed data types, such as phone numbers or addresses. In addition, the video demonstrates how to extract characters from a column, such as extracting the first or last few characters from a column. This technique can be helpful when working with columns that contain complex data. Finally, the video shows how to split columns into rows, which can be useful for analyzing data in a more granular way. This technique involves splitting a column into multiple rows based on a delimiter or a specific character. Overall, this YouTube video provides a thorough and practical guide on how to split columns in Power Query, covering a range of techniques that users can apply to their own data analysis needs.