Forum Discussion
Solved
Remove rows based on category column
Hello, guys. Need help with some ETL stuff. I have a table that comes to me bringing the following data: Store Product Department Store Category Values 1 Alpha A 12345 1 B...
The easiest way is to reformulate your selection criteria to select rows where [Store Category] <> "B" or ([Product Department] <> "Beta" and [Product Department] <> "Caos").
First select [Store Category] <> "B" to create base code:
then adjust the generated code (in the red rectangle in the picture) to:
= Table.SelectRows(#"Changed Type", each [Store Category] <> "B" or ([Product Department] <> "Beta" and [Product Department] <> "Caos"))
The easiest way is to reformulate your selection criteria to select rows where [Store Category] <> "B" or ([Product Department] <> "Beta" and [Product Department] <> "Caos").
First select [Store Category] <> "B" to create base code:
then adjust the generated code (in the red rectangle in the picture) to:
= Table.SelectRows(#"Changed Type", each [Store Category] <> "B" or ([Product Department] <> "Beta" and [Product Department] <> "Caos"))
How do you delete the rows you don't want?
