Forum Discussion
How do I delete specific rows from my query tables?
Hi bradfoster,
You can filter out specific rows in Query Editor mode, similar to below if there is a date field in original table.
From above example, I filtered out records where date starts from 3/21/2018 to 3/24/2018.
Regards,
Yuliana Gu
Hi bradfoster,
You can filter out specific rows in Query Editor mode, similar to below if there is a date field in original table.
From above example, I filtered out records where date starts from 3/21/2018 to 3/24/2018.
Regards,
Yuliana Gu
How would you go about filtering out, ie removing all rows but the first one for each row that belongs to a specific category? So for instance: let's say we have 2 categories: ( cars, planes ) and let's say we have the following columns in the table: ( datetime, category ). After sorting by datetime ascending, we want to keep the first row that shows up in the table for category 'cars', and the first row for category 'planes', deleting all the rows that come after this first row, in essence the result will be a table with 2 rows only.
How would this be done in M?
Keep Top Rows.
