Forum Discussion
Solved
use wildcard characters in query editor
I am importing pdf files from a folder. Everything went well with the first file but when Part of my editing (in the query editor) is to filter column1 to remove several values. When I added a sec...
What if you make this change in red font below
= Table.SelectRows(#"Changed Type", each ([Column1] <> null
and Text.Contains([Column1],"/")=false and [Column1] <> "All"))
Zubair_Muhammad
Community Champion
Community Champion
What if you make this change in red font below
= Table.SelectRows(#"Changed Type", each ([Column1] <> null
and Text.Contains([Column1],"/")=false and [Column1] <> "All"))
This worked perfectly for this project and another file I've been trying to import. Thank you so much.
