Cleaning up 100 column names at one time? List.Zip it good!

List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary, this is a very useful function that can get you out of a bind with a pretty small number of clicks and keystrokes. A great example is having to clean several column names all at once; trickier than it sounds as you’ll know if you’ve ever tried it; and if you’ve ever tried it you’ve probably gotten 90% of the way there and gotten stuck, lamenting “If only there was a function that handled this!”. Well, this video is going to introduce you to just that function (and also squeeze in another Devo reference).

(If you’ve got an entire folder of CSVs that need to have their names cleaned up, you’re basically going to NEED this if your sanity is something you place value in.)

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.