powerquery - Power Query - best way to sub select? -


suppose have column representing object type , column representing object color. want remove blue , red fruits (example of object type) keep other red , blue objects.

how can acheive in power query ?

thanks,

just (un)select (not) matching rows

let     source = excel.currentworkbook(){[name="table1"]}[content],     filtered = table.selectrows(source, each not ([objecttype] = "fruit" , ([objectcolor]="red" or [objectcolor]="blue"))) in     filtered 

Comments

Popular posts from this blog

Ansible warning on jinja2 braces on when -

Parsing a protocol message from Go by Java -

html - How to custom Bootstrap grid height? -