Forum Discussion
Solved
FILTER NOT TEXT.STARTSWITH
Hello, i have a strange way of working in filter step. i have rows within there is the remorque word. i want to keep the rows that not start with "remorque" Table.SelectRows(#"Récupération...
Hello GeekAlfPro ,
Please use the below modified code to retain the null values..
Table.SelectRows(#"Récupération Grp", each [Genre Machine] = null or not Text.StartsWith([Genre Machine], "REMORQUE"))
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
Hello GeekAlfPro ,
Please use the below modified code to retain the null values..
Table.SelectRows(#"Récupération Grp", each [Genre Machine] = null or not Text.StartsWith([Genre Machine], "REMORQUE"))
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S