Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Compare List of Stores & List of Products per store

Highlighted
5 - Atom

I have a list of stores in question & a list of products per store. 

I need to find out if Product A, B & C are in all of the stores in question, if not, which product(s) are missing from what store and if there are any additional stores in which the products are showing up in?

List of stores in question
Store 10
Store 20
Store 30
Store 40
Store 500

 

List of productsList of stores per product
Product AStore 10
Product AStore 20
Product AStore 30
Product AStore 40
Product AStore 500
Product BStore 10
Product BStore 20
Product BStore 30
Product CStore 10
Product CStore 20
Product CStore 30
Product CStore 40
Product CStore 500
Product CStore 600
Product CStore 700

 

Thank you all in advance.

Highlighted
Alteryx
Alteryx

hi @AB1234 ,

 

Here is what i came up with. Let me now if this is what you are looking for!

 

bpatel_0-1582907757724.png

 

Highlighted
12 - Quasar

Hi @AB1234 ,

Check this for missing and additional stores. 

benakesh_0-1582908853304.png

 

Highlighted
5 - Atom

Thank you so much for your help! Your workflow works great!!!!

Highlighted
5 - Atom

What a great workflow! Thank you so much for your help!!!

Labels