need help n custom filter tool

[anonymous008_G]

Hi there,

I need help in customize filtering with the below sample data. i want to write syntax which would look for HARD in sector column and whenever it finds then filter out HARD, EMG, LONG and SHORT records which comes very first after HARD value. 

Input:-

SECTOR	GROSS	NET
HARD	1	1
ABC	2	2
EDS	3	3
PASD	4	4
MNABH	5	5
UST	6	6
EMG	7	7
PAST	8	8
LONG	9	9
PAOSI	10	10
SHORT	11	11

Output:-

SECTOR	GROSS	NET
HARD	1	1
EMG	7	7
LONG	9	9
SHORT	11	11

[aatalai]

@anonymous008_G check this workflow it should do the trick

[anonymous008_G]

Hi @aatalai -- this shouldn't work unfortunately. Can we filter out data in alteryx instructing that start filtering out the data from when you find word as "Derivative" and then stop filtering when you find word "LONG"? that means ignore prior records of derivatives and ignore after records from LONG
Can we do that?

[aatalai]

@anonymous008_G yes can you give a list of what you are expecting, i.e including derivatives 

[anonymous008_G]

Hi @aatalai -- below sample data where i want to filter the data from word derivative till word SHORT. I am looking for steps which has direct reference to the data but rather i need conditional statement. since in actual sector contains lot of data with repetitive same sectors words.

Input:-

SECTOR	GROSS	NET
ABC	1	1
EFG	2	2
Derivatives	3	3
FX-1	4	4
FX-2	5	5
FX-3	6	6
FX-4	7	7
LONG	8	8
FX-1	9	9
SHORT	10	10
FX-3	11	11
MNO	12	12
PRS	13	13
QWS	14	14
XYZ	15	15

Output:- 

SECTOR	GROSS	NET
Derivatives	3	3
FX-1	4	4
FX-2	5	5
FX-3	6	6
FX-4	7	7
LONG	8	8
FX-1	9	9
SHORT	10	10
FX-3	11	11

[aatalai · Accepted solution]

@anonymous008_G take a look at this, though it doesn't include Fx-3 as that is after Short

Let me know if this does the trick

[anonymous008_G]

@aatalai thank you, this may works.