Forum Discussion

PeRoma's avatar
PeRoma
Frequent Visitor
2 years ago
Solved

Filter on columns that also contain Tables

Hi all,   I have an xlm-file imported into PowerQuery. The imported table contains columns with "Tables" as elements. The tables can of course be expanded to show the content. Unfortunately there i...
Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    Hi PeRoma,

     

    You can try this. To select all table type values:
    Table.SelectRows( PrevStepName, each Value.Is( [YourColumnName], Table.Type))

     

    or select all text type values:

    Table.SelectRows( PrevStepName, each Value.Is( [YourColumnName], Text.Type))

     

    Where PrevStepName and YourColumnName need to be updated to reflect, the table and column to filter.

    I hope this is helpful

PeRoma's avatar
PeRoma
Frequent Visitor
2 years ago

Hi m-dekorte

 

Thanks for for the instruction. It works greate!
Thanks you very much!