Union Two Data Sets Only If SKU Exists in Both Data Sets

Question

I have two data sets: (1) historical unproductive inventory and (2) current unproductive inventory. Every month I run a process to determine the current unproductive inventory (2). If an item is flagged as unproductive, I want to bring in all historical records this item.

In simple math:

If item A in data set (2) is present, pull all records for item A out of data set (1).

How do I best go about this?

Thanks in advance for your help.

jrgo · Accepted Answer

@kheuer

After you filter 2 to your flagged items, use a JOIN tool to filter 1. May need to use a unique or summarize tool to ensure the SKU shows up once or your data from 1 may duplicate. In the JOIN tool, you can uncheck all fields from the right, assuming you connected 2 to the R input.

Afterwards, you can Union the results you filtered from 2 and J from the Join tool output that filtered 1.

If you’re still unsure how to do, please share a sample data set and I can put an example together for you.

Hope this helps!

Jimmy