Conditional filter

[anonymous008_G]

Hi there, 

Can i filter data in Alteryx with condition? I want code or Alteryx to start filtering data from word Total and stop filtering when the system reads word or character as Develop. Output data should be from Total to prior develop record from below sample data.

Sector

Total

A

B

C

D

E

F

G

Develop

A

B

C

D

[ChrisTX]

Do you want to include the row for Develop?

Not sure what "prior" means here:  "from Total to prior develop record"

[Raj]

@anonymous008_G 
please add some sample input and expected output.
will be in better position to help.

[binuacs · Accepted solution]

@anonymous008_G one way of doing this

[anonymous008_G]

Apologies if my above description was not clear. What I need is filter below input data from word Total to G (prior record of Develop) using conditional filter. My expectation is Alteryx to read word Total from input and start filtering data from this word till prior to Develop record. 

Input:- 

Sector

Total

A

B

C

D

E

F

G

Develop

A

B

C

D

Expected Output :-

Sector

Total

A

B

C

D

E

F

G

[ChrisTX · Accepted solution]

Check out the Mult-Row Formula tool.   See attached workflow.

 

Chris

[Raj]

@anonymous008_G 
one way of doing this

[anonymous008_G]

@binuacs -- Thanks for the solution. One question, if Total Word is from Record 3 or 4, how could we filter it from Total to the prior record of Develop? 

Sector

A

B

V

Total

A

B

C

D

E

F

G

Develop

A

B

C

D

Expected output:- 

Sector

Total

A

B

C

D

E

F

G

[anonymous008_G]

@ChrisTX -- thanks, this fulfills my requirement.

[aatalai]

@anonymous008_G  does this help