Forum Discussion
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...
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.