Keep only Rows where Column1 is equal to Column2

[StephenF]

Trying and failing to add this as a query step, any ideas?

Keep only Rows where Column1 is equal to Column2, delete all other rows.

[Anonymous]

You can add conditional column; column1 = column 2 then 1 otherwise 0, and then filter new column.

[StephenF · Accepted solution]

Ok, Figured this, duh, might be useful for others. You need to do a filter then edit it in the advanced editor.

#"Filtered Rows" = Table.SelectRows(#"Added Custom", each [Column1] = [Column2])