Multiple Conditions Filter

[tsilverman_]

Hello Alteryx Community,

  I am fairly new to the alteryx platform and am finding myself stuck on a particular filter request. To first explain, each row contains a key ID, that can have multiple values in another column (X). I need to filter a column with set values in one column (X), for example, "1111", "2222", "3333". However, after  have done this, I then need to filter those unique ID's to also include values "010101", "020202" etc. in column (X). The issue is that, after I filter the very first time, it only leaves me with "1111", "2222", "3333" and their key ID which then I cannot find "010101", "020202" in column X because of the previous filter.

I need a filter basically that states; of those values "1111", "2222", "3333" in column (X), which results in filtered Key ID's, which of those Key IDs also have values "010101", "020202". 

I hope this makes sense. I can provide additional details if necessary. 

[atcodedog05]

Hi @tsilverman_ 

I am using a different method i am giving list of groups (which is string) not sum (which is numeric) you are getting that error because its comparing number to string which not valid. Please use the attached workflow. "1,2" means 1st and 2nd group exist if there are more groups it be "1,2,3,.."

Workflow:

Hope this helps : )

[tsilverman_]

Thank you, this error his removed. The output now shows only one key ID on my end, when there should be many other Key ID's that fit this criteria. Any thoughts?

[atcodedog05]

Hi @tsilverman_ ,

2 checks

1. check whether there are IDs that satisfy both the condition

2. check whether in unique tool these 2 columns are selected

If still facing issue please provide sample data with issue.

Hope this helps : )

[tsilverman_]

I have made everything exactly the same including data types and amount of bytes. 

the new output is as shown:

It says 293,301 records were displayed. the "X" column to the right, shows values, however the left column only shows [Null] values.

Above, the top data input is a csv file. and the bottom is the custom text file. The text file is where I input the group and criteria, same as your file. 

[atcodedog05]

Hi @tsilverman_ 

I can you see you have MRN instead of Key ID is it selected in the unique tool. Can you please check whether there is more than 1 ID which is satisfying the condition.

[tsilverman_]

Yes there is one row. (MRN) is still blank however. And yes, MRN is in place of Key ID throughout workflow. 

[atcodedog05]

Hi @tsilverman_ 

Not sure :(. May need sample data with which you are facing issue.

[Qiu]

@tsilverman_ 
This error message indicates that you are having a data type mismatch at filter #20, which is not in the flow of @atcodedog05 .
Can you locate the filter#20, and check the data type before and after the "=".

you can Igore the two = signs, which is believed to be somehow internal operator of alteryx.

[atcodedog05]

Hi @tsilverman_ 

Try this method

Workflow:

Hope this helps : )

[tsilverman_]

I like this approach, however. I am still getting a couple of errors. I wonder if my real data I am not using correct data types available. Can I make them have all V-string types?