Alteryx to match data from 2 sheets and combine it into 1 table (in rows, multiple crit)

Rudy313

Hello guys,

I was wondering if it's possible to do in Alteryx. Please see below what I'm looking for.

I'm looking for a solution for my case.
Right now I have a file with 2 sheets where I have similar data.
In first sheet I have a Raw Data with all the food which restaurant sold and what components were used to create the dish:

I need to match the data from second sheet (screen below) based on "Component" column (and some more) and add below missing rows with data what exactly was used to create the "Dip"

Basically, the outcome should be able to match the data based on some fields and copy below each line with all the details for used product.
My expectation is to get outcome as on screen below.

Koudy

Hi @Rudy313 , I am not sure if you want to use simple dataset with only one dish (as in your exapmle), or bigger dataset with more dishes and components.

If you have simple dataset as you posted, Union tool works well for this case....

Otherwise, when your dataset contains more dishes, you could find following workflow useful...

The workflow is attached below.

Food.yxzp