Designer| How to check two weeks of data, and count values not present or new

Question

Hello everyone, relatively new to Alteryx here. I just wanted to know if there's a way to check two weeks of data (two excel sheets), and if a value is still present that second week to leave it as is, and if it is no longer present then to count it. Then with the next following week's data, if a new value shows up or if another one is no longer present, then count that as well. Something like what the tables show. Please let me know. Thanks!

week: 03-01-22

values 01231234

week: 03-08-22

values  null +1 or 'gone' 1234 12345+1 or 'new'

NeilParrott · Answer

Hi Noah, here's an updated workflow with a new "Priority" column.

dropped_or_new_values_v2.yxmd

noahrainegdj · Answer

Hello! This definitely gives me an idea of how this could go. Thank you so much for your time

NeilParrott · Answer

Hi @noahrainegdj ,

I'm not quite sure if this is the actual workflow format that you were looking for, but it does give you an idea of what was "dropped" and what is "new". The union tools at the ends give you a different view based on potential use of the data from here.

Hope this helps!

Neil

dropped_or_new_values.yxmd