APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table

#exceltips #powerquery #exceltutorial #msexcel
--------------------------------------------------------------------------------------
Chapters:
0:00 Intro
1:15 Explain the function: List.RepalceMatchingItems
6:16 Convert a record to a list
8:00 Convert a table to lists
9:46 Bulk replace values using List.RepalceMatchingItems
11:37 Convert group of lists to a table
16:00 close
--------------------------------------------------------------------------------------
To watch the full playlist
--------------------------------------------------------------------------------------
To download the working files:
--------------------------------------------------------------------------------------
To subscribe:
--------------------------------------------------------------------------------------
To follow on Facebook
--------------------------------------------------------------------------------------
To follow on LinkedIn:

[jeromeastier]

Excellent! Exactly what i was looking for, Thanx!!

[paolomartinello]

Are you kinda genius maybe? Many compliments for this video!

[aatsw]

Very nicely done, learned something new today. Thanks for sharing. Merry Christmas & Happy New Year!

[jiky]

when i am giving this command List.ReplaceMatchingItems([Column1], oldnew) i am getting list of errors instead of list of list

[jiky]

I am doing exactly same steps still i am geeting error when replacing

[ShaalanHalahleh]

How can I change the values in each column with different helper tables?

[bagnon]

I also tried this with unpivot the columns, do the List.ReplaceMatchingItems step on the one Values column, Pivot the table back and then Table.ExpandListColumn.

[kailash]

10:45 This will give a Formula.Firewall Error. Not when writing it, but after reopen the file, even with your final exercise file. But the final result is not affected.

[lpenatti]

It worked very well! Thanks for sharing. However, in the last step, all column types are changed to general (acb123). Is there a way to keep original column types, like you did for column names?

[roywilson]

Another interesting video, thanks for uploading.

[manjeetmarothiya]

Hi Thanks for making video on List M code, thanks for explaining this Topic in very Deep and easly.

I request you Please make a Video on How to Import a Zip or Gzip CSV File in Power query with the Help of Import zip file M - code.


Thanks,

[zahoorsarbandi]

Very verry useful tricks. in daily working with power query these tricks are too much needed. Thanks for such a nice content which helps a lot.

[dhaval]

Sorry this way too complicated, I have simpler solution first unpivot all the columns expect first 2 columns, then merge the two table, then replace null value with some place holder values then use ReplaceValue to get value from other column, then delete the 2nd column the pivot back and done, in this case the number of columns in first table and number of replacement in second table don't matter at all

[raissabenoccithibes]

Amazing class! Useful tips I was looking for!

[syedaneesdurez]

Very helpful Video to do our daily tasks. Mashallah