Remove rows based on conditon

[learnalteryx]

Hi Alteryx Community,

I need help. I want to remove entire ROWS based on a condition. 

ROW	Item	Amount	Category	Requirement
1	A	100	T
2	A	100	M	Remove this row only
3	B	200	M
4	C	500	T
5	D	300	M
6	F	400	T
7	F	400	M	Remove this row only

I want to remove Row 2 and Row 7 based on the below condition

I will mention an example for Row 2 below

Condition 1 - For the Column Name "Amount", The value of the current cell ( Row 1 ) and the next cell ( Row 2)  should be same, Here both are 100, If it is same then go and check Condition 2

Condition 2 Check if Row 1 - Category is "T" , If this condition is met then go to Condition 3

Condition 3 It should check in Row 2 if the Category is "M".

If all the conditions are met, then it should delete the entire ROW 2 with value M as category  

[DenisZ · Accepted solution]

Please see attached workflow

Please mark as solved if it solves the issue

[binuacs · Accepted solution]

@learnalteryx One way of doing this

[ShankerV]

Hi @learnalteryx 

Please find one way to reach solution.

Shanker V

[ShankerV]

Hi @learnalteryx 

Step 1: Input

Step 2: 

if ([Amount]!=[Row-1:Amount])
then "Yes"
elseif ([Row-1:Category]!="T")
then "Yes"
elseif ([Category]="M")
then "Remove"
else "Yes"
endif

Step3:

Results for you:

Shanker V

[ShankerV · Accepted solution]

@learnalteryx 

Did your issue got resolved?? Derived your expected solution??

Many thanks

Shanker V

[learnalteryx · Accepted solution]

Yes , Thank you