Forum Discussion
Remove rows
Hi,
I'm having data set includes call details. Some calls are replace by other users. So one call can be replace by many users. But i want to get the terminated user details because he is the perosn who resposible for that call.
So, I want to delete replaced value and only need to show terminated person details, How can i Do that?
Please check the below table. I want to remove the highlighted rows.
| Date | Caller ID | Destination | Status | Ringing | Talking | Totals | Cost | Reason |
| 1/12/2018 | Marry | 98728892 | answered | 0:00:00 | 0:00:08 | Mary replaced by | ||
| Jack | 99982725 | answered | 0:00:00 | 0:00:17 | Mary replaced by Jack | |||
| Peter | 92882882 | answered | 0:00:04 | 0:01:50 | Jack replaced by Peter | |||
| Jude | 82272882 | answered | 0:00:04 | 0:00:11 | Jude was joined | |||
| Rose | 82727822 | answered | 0:00:00 | 0:03:43 | 0:06:17 | 3.9 | Terminated by Rose | |
| 1/12/2018 | Chan | 83773883 | answered | 0:00:04 | 0:01:50 | 0:06:17 | 3.9 | Terminated by Chan |
Add a conditional column to filter out the "replaced" value rows with blanks. Then, remove the blank rows.
Then in modelling tab, simply filter the blank rows or generate the following Power query code:
= Table.SelectRows(#"Changed Type", each [Custom] <> Blank())
Please accept the solution if I answered your query.
4 Replies
Add a conditional column to filter out the "replaced" value rows with blanks. Then, remove the blank rows.
Then in modelling tab, simply filter the blank rows or generate the following Power query code:
= Table.SelectRows(#"Changed Type", each [Custom] <> Blank())
Please accept the solution if I answered your query.
Hi cham
Does the last column "Reason" exsit in your dataset?
or is it written by you here to illustrate the case?
If the last column "Reason" doesn't exsit in your dataset, how do i find which rows need to be deleted?
Best Regards
Maggie
Hi Maggie,
Reason column is exist in my dataset.
Hi cham
Does sbelanix 's suggestion really help you?
If it does, could you kindly accept it as a solution so others may benefit from it.
If not, please let me know.
Best Regards
Maggie
