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 appl...
Data Protection
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"