Forum Discussion

parry2k's avatar
parry2k
Super User
4 years ago

Let's explore how the Power Query List function helps to clean the data - Partial Search and Replace

In this video, we will learn how to use List.PositionOf function by writing our own comparer logic for data cleaning/transformation. We will match the partial value of a column and replace it with the correct value.
 
The same can be achieved by many other methods but the purpose of this video is to showcase how to create your own comparer function.
 
 
 
 
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi parry2k ,

    Thank you for sharing. Please mark the answer to close the case and help more people to find the answer.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.