Forum Discussion
M Code to remove blanks and nulls from rows in a single sweep
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
Super UserUse Table.Buffer and Table.AddKey to speed things up.
Well, I'd still have the convoluted decision tree to try and program. I'd much prefer to simply operate on the columns that directly affect whether I keep a row. And a lot of the query load time is spent in creating calculated columns (30) and measures so the PQ portion of is just a portion of the total load. (Since the voucher file is standalone the links to related requisitions, purchase orders, receipts, matches etc., as well as subsequent calculated column computations, have to be done.)
- lbendlin
What would you like to get help with?