Forum Discussion
Solved
Keep only Rows where Column1 is equal to Column2
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.
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])
You can add conditional column; column1 = column 2 then 1 otherwise 0, and then filter new column.