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...
Need Help
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.