Forum Discussion
Solved
Table.Skip won't work with Text.Contains?
Greetings, I hope there is an easy solution I am missing, but here is my quandry: Table.Skip(Source, each [Column1] <> "UNIT:10917") will remove records before row 7 and this is what I wa...
HI WBarberena
I believe you need to negate the condition:
Table.Skip(Source, each not Text.Contains([Column1], "UNIT:"))From the Table.Skip documentation:
"the rows that meet the condition will be skipped until a row does not meet the condition."
Does that work as intended?
HI WBarberena
I believe you need to negate the condition:
Table.Skip(Source, each not Text.Contains([Column1], "UNIT:"))From the Table.Skip documentation:
"the rows that meet the condition will be skipped until a row does not meet the condition."
Does that work as intended?
And there is the embarrassingly simple answer I needed. Thank you OwenAuger!