Forum Discussion
rosswinter09
5 years agoNew Member
Expand column with functions in each row
I have a query from an OData feed. It returns two columns (an index) and another column that contains data with a type: function. Each of these functions contains a table (with 5 columns and w...
jennratten
4 years agoSuper User
It looks like the function does not require any inputs, so if you are just trying to invoke the function for reach row of the table, please try something like the script below. Add this line right after #"Removed Columns 1", replacing the rest of the steps. This should result in a new column being added to the table, the contents of which is a table on each row.
FnResult = Table.AddColumn ( #"Removed Columns 1", "FnResult", each [GetMissingKbs]() )