Include Columns from List/Table

[StevenMorgan]

Hi there,

I'm looking to Remove or Include columns based on their presence in a lookup table. I've seen several articles on removing columns that contain specific terms in the Column name but I'm struggling to adapt to loop through or search and match against row values in another table.

Example:

Table to remove cols:

Firstname	Surname	Address 1	Address 2
data	data	data	data

Target columns:

Column Name	Keep/Remove
Firstname	Keep
Surname	Keep
Address 1	Remove
Address 2	Remove

Target output:

Firstname	Surname
data	data

Any help appreciated.

Thanks,

Steve

[StevenMorgan]

Thanks @latimeria - that is the idea however I would like to populate ColumnToKeep variable with rows from another table - is that possible?  I guess if I convert rows to a list and insert to that variable?

Steve

[latimeria]

Yes, 

Table.ToColumns should be your friend

[StevenMorgan]

Excellent - thank you.

Final solution for reference.

let
Source = data,
GetColumnNames = Table.ToColumns(ColNames),
ColumnToKeep = GetColumnNames{0},
KeepCols = Table.SelectColumns(Source, ColumnToKeep)
in
KeepCols

[latimeria · Accepted solution]

Hi @StevenMorgan ,

If this can help:

let
    Source = #table({"Firstname", "Surname", "Address 1", "Address 2"}, {{"data","data", "data", "data"}}),
    ColumnToKeep = {"Firstname", "Surname"},
    //ColumnNames = Table.ColumnNames(Source),
    Custom1 = Table.SelectColumns(Source, ColumnToKeep)
in
    Custom1