Forum Discussion
Learner86
Helper I
Helper IDelete 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...
Samarth_18: Thank you very much for the solution.
Samarth_18
Community Champion
Community ChampionHi 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
Learner86Samarth_18: Thank you very much for the solution.
- Samarth_18
Great! Learner86 it helps you. Kindly accept my answer as solution so that people can find it more quickly.