Table.RemoveColumns(Table, Table.Column.Values)

[pbyrne98]

Someone is going to ROFL on this one.

Three queries:

1. Query 1 : Table with all columns in a CSV

2. Query 2 : Table with one column with list of columns I want to keep in query 1

3. Query 3 : Query 1 Table with all columns removed excluding column names in the table in Query 2.

What is the syntax for Table.RemoveColumns or KeepColumns that allow me to end up with Query 3?

[wdx223_Daniel]

Table.SelectColumns(Query1,Table.ToColumns(Query2){0},MissingField.UseNull)

[BA_Pete]

Hi @pbyrne98 ,

Try the following for your Table3 query:

let
    Source = Table.SelectColumns(Query1, Query2)
in
    Source

Pete

[pbyrne98]

Thanks Pete,

This is what pops up when I put it in, it maybe that the Query2 is a table and not a list?

Expression.Error: We cannot convert a value of type Table to type Text.
Details:
Value=[Table]
Type=[Type]

Added pictures of the Query 1, 2 and 3 to help.

[AlexisOlson]

You're nearly there. The issue is that tblPACfields is a table rather than a list like the function expects.

You can fix this by specifying the column from the table (since table columns are lists).

Table.SelectColumns(pm_project, tblPACfileds[pm_project_fields])

Or, assuming the query pm_project_fields is already the appropriate list (rather than a table).

Table.SelectColumns(pm_project, pm_project_fields)

[pbyrne98 · Accepted solution]

That seemed to do the trick, in the end I referenced the original query (pm_project) to create a 'Source', add a customised step with the following command and voila 🙂

= Table.SelectColumns(Source, tblPACfields[pm_project_fields])