Omitting rows/jobs from a master list, from another list of specified jobs.

[dottman]

I've got a master list of 1,488 jobs and need to remove 106 jobs from another list. Basically I need to get that list of jobs down to the 1,382.

I generate a list of 106 jobs in alteryx called "in scope" and it's dynamic, so will be changing each time I run the report. My next step is generating a list of "out of scope" jobs and need to grab these other 1,382 so I can join with other data to create a report.

Images of both lists are attached, would really appreciate any help!

[Prometheus]

@dottman You could join the master list to the list of jobs to omit. Anything that doesn't join is the new master list.

 

 

 

[ladazhome]

The way I would do it is filtering the records you need to filter out from, then add a new field (column). After it use a join and then later on remove those records filtering out the column you just added