Calling out something new in month over month data

Hello! I am newer to Alteryx and loving it so far. I have a problem that I am struggling to solve, and haven't quite found what I needed in my searches.

I have a big data set that gets updated monthly, coming from an external source. This feeds through a workflow with many different filters to produce my outputs, which is working really well. What I need now is a check to see when something new is showing up in 10 of my columns I use to filter....

For example, one filter is on "Employment Status." There are currently 8 different Employment Statuses, and I want to know when a new one is added.

I was able to export a listing every month of all my fields -- example attached -- but I need Alteryx to look at two months and tell me what's new. I have tried a join, but I think I need the join to look at all the columns separately? (The rows are meaningless.) Do I need 10 separate inputs per month (20 inputs) and 10 separate joins? It seems like there would be a more efficient option?

Thanks!!

Field Options example.xlsx

Datasets

Join

Accepted answers

PhilipL

@Garabujo7 wrote:
Hello @HannahGriffith ,
You can transpose the column names and the join them to get the ones that are new.
Gabriel

With the transpose method, if you feed files in for both months, be sure to filter out null/empty values:

All comments

PhilipL

@HannahGriffith My first thought is to do Summarize (or Unique) on the values in your 8 fields for each month and compare them using Joins on the Summarized/Uniqued values. Your L and R outputs from the Joins will tell you what is different month to month.

Garabujo7

Hello @HannahGriffith ,

You can transpose the column names and the join them to get the ones that are new.

Gabriel

Garabujo7

Also, as @PhilipL states, you can use the summarize and then a join to identify the ones that are new:

Gabriel

PhilipL

@Garabujo7 wrote:
Hello @HannahGriffith ,
You can transpose the column names and the join them to get the ones that are new.
Gabriel

With the transpose method, if you feed files in for both months, be sure to filter out null/empty values:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703