![]() Alternatively, you can select and right-click the column that you want to dedupe, and then choose Remove Duplicates from the context menu. Remove case-sensitive duplicates as explained above.For a case-insensitive deduplication, you need to modify the M code for the query. Please keep in mind that this standard "Remove Duplicates" operation will eliminate only the rows that are identical in every way, including the letter case. Select the column(s) you want to check for duplicates, then go to the Home tab, and click on Remove Rows > Remove Duplicates. To eliminate duplicate rows in your data, Power Query offers the Remove Duplicates function. Select the columns you want to clean up, go to the Transform tab > Text Column group and click Format > Trim or Clean. To remove any leading or trailing spaces, or any other unwanted characters, you can use the Trim and Clean functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |