Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

#"Filtered Rows" = Table.SelectRows(#"Expended Row", each true)

Hi, I encountered this query in the advance query editor.

 #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each true)

I have no clue what "each true" means and it is taking 20 lines from my table.

Thanks

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    In my test, above query returned the same rows as that returned by its previous step. Usually, we add a filter condition which returns bloon values "True/False" after "each" function. But "each true" mean it is always "True", in other words, there is no filter, so, it would return all data rows without filtering.

     

    In your scenario, please check the result of previous step #"Converted to Table". It should also return 20 lines.

     

    Regards,

    Yuliana Gu

    "

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-yulgu-msft

      Thanks for the reply. There are no boolean values in my data and it is still taking off 20 rows of data. That is was I was curious.