need help n custom filter tool

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

Help

Accepted answers

aatalai

@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

need help n custom filter tool v2.yxmd

All comments

aatalai

@anonymous008_G check this workflow it should do the trick

need help n custom filter tool.yxmd

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

@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

need help n custom filter tool v2.yxmd

anonymous008_G

@aatalai thank you, this may works.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703