Forum Discussion

ialayidi's avatar
ialayidi
Frequent Visitor
2 years ago

No data shows after applying a Row filter using Advanced Editor

Hello, 

 

I'm using an ODBC connection and have a table with over 13 million rows. I only need to analyze a certain category named Rework. The preview does not load due to size of table. I can apply the row filter manually through Advanced Editor, however; it is not giving me any rows, nor is there any error! The main objective here is to reduce the refresh time. Please help! Thanks! 

Code: 

 

 

 

 

 

= Table.SelectRows(TRANSLOG_Table,each ([LOC_DESC]) = "REWORK")

 

 

 

 

 

 

 

Data Protection

4 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Can you try with Contains and make sure it's case sensitive:

     

    = Table.SelectRows(TRANSLOG_Table, each Text.Contains([LOC_DESC], "Re"))

    • ialayidi's avatar
      ialayidi
      Frequent Visitor
      2 years ago

      It took forever to run the code, and gave me the same result as using "REWORK" 

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Can you create another subset table of this and distinct the LOC_DESC column and see the actual value?

    • ialayidi's avatar
      ialayidi
      Frequent Visitor
      2 years ago

      It keeps thinking for over an hour without a status...