Forum Discussion
Help with adjustment in table
Thanks, ImkeF
I got the following error:
Expression.Error: We cannot convert Table value type to type List.
Details:
Value=Table
Type=Type
Cannot understand that that message, but it's probably due to the manipulation of the code that you've done.
So please go a different path instead:
Copy the first code I've given you into a new query: New query -> open the advanced editor and replace everything in there with the code I've given. This returns a function that has just one parameter: Your table.
In another query, just import your table that shall be manipulated.
Now, when you click on the query with my function code, you should see a window that allows you to select your table via the dropdown field.
Click "Invoke" and the results should appear.