Forum Discussion
Delete rows based on conditions
Dear community,
how can delete rows based on conditions? I need something like this: if the costs are smaller then 3800 and if the frequency is bigger 1 and the Mdt ist unequal 30 then delete the rows. How can I do this?
Unfortunately, I can't add a table to this post bacause I get the message "marked as spam". I tried different thing but it doesn't work.
Many thanks for your help!
Samarth_18: Thank you very much for the solution.
6 Replies
My problem addresses the following table:
I want to delete the rows 1,3 and 5.
Hi Learner86
You can create a custom column in trasform data tab with below code:-
if [costs] < 3800 and [Frequency] > 1 and [mdt] <> 30 then 1 else 0Now filter your custom column of table by selecting "0"
and then click on "close and apply"
You will see your desired result.
Thanks,
Samarth
Samarth_18: Thank you very much for the solution.
Great! Learner86 it helps you. Kindly accept my answer as solution so that people can find it more quickly.
