In this video, let's talk about List.Accumulate() Power Query function. This versatile function can apply an operation on all items in a list and return one final value. We use this little gem to perform multiple find / replace in a piece of text.
This technique is useful for replacing keywords or changing text en masse.
For full discussion, example file and more, please visit:
chandoo.org/wp...
#PowerQuery #List.Accumulate #KeywordReplacements #FindReplaceAllItemsExcel
Негізгі бет Multiple Find / Replace with List.Accumulate() ~ Power Query
No video
Пікірлер: 91