Custom Filter

[Mzaheer24]

Hello,

How can we filter account  which has more than 1 count. Below is the example.

Account	Count
I01770402	3
I01770402	3
I01770402	3
00211319	2
00211319	2
22051	1
6785270	1
A69698	1

[davidskaife]

Hi @Mzaheer24 

Taking your query very literally using the Filter tool, where the Count is greater than 1

I suspect there might be more to the query than this though, so you may want to add some more detail to what it is you're looking for if that is the case

[alexnajm]

[Count]>1 should do it

[Mzaheer24]

I want to create two output with the name of insured and account.

 I don't want to repeat account which has a more than two count in insured output.

[Mzaheer24]

I want to create two output with the name of insured and account.

 I don't want to repeat account which has a more than two count in insured output.

[Hsandness]

@Mzaheer24 If you have a desired output it might be easier to understand what the goal is. The attached workflow is removing duplicate accounts by first checking the count then only returning unique insured row values.

I'm combining this output with the insured rows that only have a count of one. From there, you can create your two output files. I wasn't sure what you needed for the output files, so I just selected the Insured column as one output and the Account column as the other.

[Mzaheer24]

I am not able to open PNG file. Can you share workflow

[apathetichell]

@Mzaheer24  ---- https://community.alteryx.com/t5/Interactive-Lessons/Filtering-Data/ta-p/76301

[Hsandness]

I would recommend watching the training on filtering tools that @apathetichell linked below. 

[alexnajm]

Agreed with everyone above - @Mzaheer24 you have enough information to try this out, or if you provide your expected output we can help further. We can't guess what you want without seeing it!