Forum Discussion

Helper I

9 years ago

Need help

Hi In a particular folder, i want to merge all files(txt files) from sharepoint. i got it for merging all files. but the thing is i want to filter the file if the particular word is present insid...

Community Champion

9 years ago

If you apply your filter to the example query and the word is not found, then the result will be an empty table.

If the word is found then you want to return the entire table, so you can add a step in your example query like:

Result = if Table.RowCount(#"Filtered Rows") = 0 then #"Filtered Rows" else Source

where Source is the step prior to the filter step.

Consequently, you will get null values for empty tables in your combined table (in your master query) after expanding.

There you can add a step to filter out the null values.

Helper I

9 years ago

I meant, if the word is found in the file, i dnt want that file not a particular row in the file.

MarcelBeug
Community Champion
9 years ago
Thanks for confirming I understood correctly.
Watch this video for better explanation.
It reads files from a folder (rather than Sharepoint, but the concept is the same) and returns only files containing the keyword.
- kalpana
  Helper I
  9 years ago
  Ok Thanks:)
- kalpana
  Helper I
  9 years ago
  Thank you very much Marcel
  
  I need one more help. There are two tables . i want to do lookup to get the values from other table .
  
  Need formula for lookup with condition.
  
  I tried this = Lookupvalue(result column name, search column name, search value ) but here i want to put condition,
  
  Is it possible.?
  - MarcelBeug
    Community Champion
    9 years ago
    Doesn;t look like (standard) Power Query to me, so I don't think I can help you.
    
    If it isPower Query, then I need more clarification, because I don't understand exactly what you are looking for.
    
    Otherwise I would advise to raise a new topic with a descriptive title (not "Need Help"), something like "How to perform a conditonal lookup in DAX".