Forum Discussion
Need help
I dnt want to filter particular row in the file. i want to filter that file if that particular word is there inside the file
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.
I meant, if the word is found in the file, i dnt want that file not a particular row in the file.
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.
Ok Thanks:)