Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to Filter Columns from a binary

Hi guys, need some help on this I have imported data source from a folder containing 2 excel workbooks.  So far it has been working well until the last step which is to filter to keep the columns ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    each keyword is missing. Use below Table.SelectRows

    Table.SelectRows([Custom.2], each [Column4] <> "Yearly")

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

each keyword is missing. Use below Table.SelectRows

Table.SelectRows([Custom.2], each [Column4] <> "Yearly")