This is a truly great video. I have watched several bulk replace videos from other PQ KZitemrs 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!!!
@kebincui
Жыл бұрын
Excellent👍👍
@hseyedagha
10 ай бұрын
That was awesome, saved me 5 hours probably and increased performance hugely.
@basensei8699
10 ай бұрын
that so great!
@siddheshamrutkar8684
Жыл бұрын
Superb.. 🤘
@roywilson9580
Жыл бұрын
That's a neat trick :)
@mnowako
5 ай бұрын
Mind blowing! Many thanks!
@bghneim
8 ай бұрын
Excellent thank you
@jianlinchen7978
Жыл бұрын
勉強になりました
@Rahul.parmar8439
5 ай бұрын
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
@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: kzitem.info/news/bejne/t418v3ljfYGqn6Q
@basensei8699
Жыл бұрын
i love your videos
@ajayrathod7777
2 ай бұрын
getting error in last step :Expression.SyntaxError: Token Comma expected. code = Table.TransformColumns(Source, {}, each List.ReplaceMatchingItems({_}, Find_Replace List){0})
@alterchannel2501
8 ай бұрын
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?
Пікірлер: 18