Forum Discussion
Fastest function to bulk replace different values in a single column?
I have a large data set and I there is a particular column that always has typos and I don't have access to the source. In PQ there several ways to replace values in a column, but I want to know whic...
Hi StrPod
Mostly the purpose of using functions like list.accumulate and list.replacematchingitems and many other functions is to simplify the M codes, or to make some replacements more dynamic without spending too much time modifying code manually and repeatedly. This doesn't guarantee that it will run faster, but more often than not, it's meant to make it faster and easier to maintain the code.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!