Multiple Conditions Filter - Csv Example Included

tsilverman_

I have included a csv with random numbers. I am working on a project in which I need multiple conditions to be met and am stuck on the particulars. This post is a follow up to a previous question, but wanted to provide more detail.

Steps 1 is to filter the “Code” column to include values “11111”, “22222”. After this, I want to keep the “Random Unique ID” values that correspond to those new criteria in the “Code” column.

Step 2 - Out of the “Random Unique ID” column, which rows also have values “10101”, “20202”, “30303”

Step 3 – Out of that resultant, which “Random Unique ID” also has “888888” as well as “99999999” in the “C.Uniq Integers” column.

My own data set contains multiple null values / blank values in a number of rows and columns as well.

exp_csv_for_alteryx.csv

Luke_C

Hi @tsilverman_ 

Here's an example of the first filter, however not seeing any data that would match step 2, 10101,20202,30303 appear to be codes, not random unique IDs in your sample.