delete rows
2 Topics
Delete rows based on calculated number
I’m having trouble to delete rows based on calcluted # number. I have 3 tables. 1. A table that defines unique list of call (call)[List] per day (call)[Date]. each call has an answer status (call)[Status]. I created a column to have a unique field (call)[Key] Call which appears as following : | List | Status | Date | Key ------------------------------------------------------------- | List1 | A | 2022-02-09 | List1 2022-02-09 | List1 | A | 2022-02-09 | List1 2022-02-09 | List1 | DO | 2022-02-09 | List1 2022-02-09 | List1 | DO | 2022-02-09 | List1 2022-02-09 | List1 | DO | 2022-02-09 | List1 2022-02-09 | List2 | A | 2022-02-09 | List2 2022-02-09 | List2 | DO | 2022-02-09 | List2 2022-02-09 | List2 | DO | 2022-02-09 | List2 2022-02-09 | List3 | A | 2022-02-09 | List3 2022-02-09 | List3 | DO | 2022-02-09 | List3 2022-02-09 | List3 | DO | 2022-02-09 | List3 2022-02-09 | List1 | C | 2022-02-10 | List1 2022-02-10 | List2 | A | 2022-02-10 | List1 2022-02-10 | List2 | DO | 2022-02-10 | List1 2022-02-10 | List2 | A | 2022-02-10 | List1 2022-02-10 | List3 | DO | 2022-02-10 | List1 2022-02-10 | List3 | A | 2022-02-10 | List1 2022-02-10 2. A table a repository Status (Status )[Names] and (Status)[Status]; The join with the (Call)table is done with the (Status)[Status] Status which appears as following : | Names | Status | ----------------------------- | answer | A | | drop out | DO | | cancel | C | 2. A table Number with a calculated column (Number)[#drop] ; The join with the (Call)table is done with the (Call)[Key] Number which appears as following : | Key | # drop | ------------------------------------- | List1 2022-02-09 | 2 | | List2 2022-02-09 | 2 | | List3 2022-02-09 | 1 | | List1 2022-02-10 | 0 | | List2 2022-02-10 | 1 | | List3 2022-02-10 | 1 | I want to create a new table called NewDF by deleting the rows based on (Number)[#drop] and with (Status )[Names] = "drop out" Desired result is the following: | List | Status | Date | Key ------------------------------------------------------------- | List1 | A | 2022-02-09 | List1 2022-02-09 | List1 | A | 2022-02-09 | List1 2022-02-09 | List1 | DO | 2022-02-09 | List1 2022-02-09 | List2 | A | 2022-02-09 | List2 2022-02-09 | List3 | A | 2022-02-09 | List3 2022-02-09 | List3 | DO | 2022-02-09 | List3 2022-02-09 | List1 | C | 2022-02-10 | List1 2022-02-10 | List2 | A | 2022-02-10 | List1 2022-02-10 | List2 | A | 2022-02-10 | List1 2022-02-10 | List3 | A | 2022-02-10 | List1 2022-02-10 Please, any help? Thank's in advanceSolved1.1KViews0likes3CommentsHow to delete rows where the quantity is equal to 0
best regard I am bringing a query from SQL Server and in the table I have a field called quantity, it is numeric and there are rows with 0; I want the information upload without 0, how was the upload done? Thank you. I found the command Table.SelectRows but it does not work correctly, I do it from query editor and write the command does not work #"Filtered Rows" = Table.SelectRows( t_datos_ventas, each [cantidad] = 0 )Solved1.7KViews0likes3Comments
