Zoe Locke 10/8/2018

Tidyverse 'Starts_with' in M/Power Query

Read Original

The article details a practical data wrangling problem: filtering columns in Power Query (M language) based on name suffixes, inspired by the concise `ends_with()` function in R's Tidyverse. The author shares their solution for removing metadata columns (ending in '_source' and '_sourceid') from a HubSpot API dataset within Power BI, providing the M code and comparing its verbosity and functional programming style to the R equivalent.

Tidyverse 'Starts_with' in M/Power Query

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

No top articles yet