Forum Discussion

MittenState's avatar
MittenState
Regular Visitor
2 years ago
Solved

M Code to remove blanks and nulls from rows in a single sweep

I have multiple data sets with 10+ million each rows from our ERP that are subject to name and format changes by our IT team.  CSV dumps are provided daily starting at 3am running until 6am or so, th...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here are all the transforms, including the changed types and column names. This replaces the entirety of your function (minus the removal of duplicates, but that's easy to add).

     

    h/t to Mr. von Neumann

MittenState's avatar
MittenState
Regular Visitor
2 years ago

Is there a good M book to have, like Rob Collie's DAX book, to get a handle on M?  I find it a very dense language... between treating something between a list and a record, square vs curly brackets, the "_" operator, a lot of power is tucked into small space.