Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
1 year ago
Solved

Power Query conditional column selection

Hi , I wanted to select columns that contained a certain value and came up with this , but has anyone any ideas for a different approach ? here just selectign columns  that contian "X".  BTW, should...
Need Help
Show and Tell
  • PwerQueryKees's avatar
    PwerQueryKees
    1 year ago

    Your table = Source.

    You can use this anywhere you would normall use SelectColumns (or RemoveColumns)

     

    = Table.SelectColumns(Source,List.Select(Table.ColumnNames(Source), each Text.Contains(_, "X", Comparer.OrdinalIgnoreCase)))

     

    I made the match case INsenistive, remove the Comparare.OrdinalIgnoreCase if you don't want that.

Dicken's avatar
Dicken
Post Prodigy
1 year ago

Interesting, I'll leave it open see if anyone else repsonds,  

Richard. 

m_dekorte's avatar
m_dekorte
Resident Rockstar
1 year ago

Hi Dicken 

Table.SelectColumns(
    Source, 
    List.Select(
        Table.ColumnNames(Source), 
        each Text.Contains(Text.Combine(Table.Column(Source, _), "|"), "X")
    )
)