Power Query - Exclude/Filter rows where the value for the a specific field has a length > 4 RRS feed

  • Question

  • Is there a straightforward option to exclude loading rows with Power Query beyond the typical text filter?  I would like to include a "filter" where Power Query does not import any rows where Text.Length ([Field_Name_ABC) > 4.  I am trying to find the correct syntax to exclude rows based on their length of their column beyond creating a new field and filtering out all records where the length of Field_Name_ABC are greater than four (which seems relatively inefficient for large data sets).  Thank you
    • Edited by LeaningTree Tuesday, October 6, 2015 3:10 AM
    Tuesday, October 6, 2015 3:07 AM


All replies