Select column names from a list of column headers

[monojchakrab]

Hello Good people,

This possible is a simple solution....

• I have a list of all column headers as follows as a part of a step within a query :

• I will feed this list into another step but I dont want to carry all the columns. So I created another list for the column headers which I want to keep from the list above :

• I have tried to write a code as below :

List.Select(
FirstList,
(_)=> List.ContainsAll(FirstList,SecondList)
)

But this is giving an error....is there some other way to do this or is this code writted wrong and the syntax can be modified?

Any help much appreciated

Best regds.,

[Fowmy]

@monojchakrab 

You can use List.Intersect function
List.Intersect( {FirstList,SecondList} )