Power Query - Bulk Replace Values in One Step 🔄📊

🚀 Dive into today's tutorial as we unlock the secrets of Power Query! Learn how to swiftly replace values in bulk, making your data processing smoother than ever. 📊 Whether you're dealing with errors, inconsistencies, or just need an update, this guide has got you covered. 🧠 Master the art of bulk editing in Power Query and transform your data analysis game! 🔥
#dataanalytics #data #powerquery #mquery #powerbidesktop #powerbi
Links
File Link
github.com/jbo...
Functions Links
table transform columns
learn.microsof...
list.replacematchingitems
learn.microsof...
table.torows
learn.microsof...

[@garywilhelm2299]

This is a truly great video. I have watched several bulk replace videos from other PQ CZcamsrs and BA Sensei has by far the most efficient code for accomplishing this task. It is genius to use the 3rd (default transformation) argument of the Table.TransformColumns function to replace values in ALL columns using the translation table. Great stuff!

[@basensei8699]

thank you very much!

[@patrickyoung2106]

Yes, back with another tutorial!!!

[@hseyedagha]

That was awesome, saved me 5 hours probably and increased performance hugely.

[@basensei8699]

that so great!

[@mnowako]

Mind blowing! Many thanks!

[@roywilson9580]

That's a neat trick :)

[@kebincui]

Excellent👍👍

[@siddheshamrutkar8684]

Superb.. 🤘

[@bghneim]

Excellent thank you

[@jianlinchen7978]

勉強になりました

[@josh_excel]

If you wish to replace partial values like letters in a word, I have a couple of methods include this one using recursion:
czcams.com/video/VWFYE-DOylo/video.html

[@basensei8699]

i love your videos

[@Rahul.parmar8439]

replace bulk with begin with replace possible
Example name in Mr. Dr. Miss Miss.. m/s begin with value replace use to power QUERY possible

[@alterchannel2501]

this is great, you are the only one who nailed this solution . others use list.accumulate, but that method doesn't work properly. Only one question, on very big datasets will this be slow considering that it is iterating all the table and not just the column we want to change?

[@ajayrathod7777]

getting error in last step :Expression.SyntaxError: Token Comma expected. code = Table.TransformColumns(Source, {}, each List.ReplaceMatchingItems({_}, Find_Replace List){0})

[@thebhaskarjoshi]

Superb.. 🤘

[@basensei8699]

Thanks 🤗