Forum Discussion
How to simplify M code for multiple actions, each on particular columns within nested tables
Hi there, I have working M-code, but it looks to me like it could be simplified significantly. Since I'm not exactly a master of M-code syntax, I'd appreciate it if someone could give me a clue as...
Actually, you don't even need to do that! Table.FillDown uses a list as it's parameter, so if you know which columns you want, you can use make a query with all the possible columns, another query with Table.ColumnNames, and then do
Table.FillUp(TableOrPriorStep, List.Intersect({NameOfListOfPossibleColumns, NameOfTableColumnNames}))
--Nate
--Nate