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])
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])