Adding a row for each match between 2 tables

[AlexP]

Hi Alteryx community!

I am new to Alteryx and I just hit my first road block.

I am working with a dataset that contains parent and child SKUs, which means that everytime I sale a parent SKU, my inventory reduction is in fact attached to each child SKU­.

I am trying to add a row to my sales dataset for every child SKU.

For example:

Dataset

Parent SKU	Sales
A	10
B	15
C	20
D	5

Parent SKU	Component
A	A1
A	A2
B	B1
D	D1
D	D2
D	D3
D	D4

I would like to add a row to my first table for each component. However, sometimes there is no component and the parent SKU is not even in the second table. In that situation, I would define the Parent SKU as Child SKU. For the example above, the combinaison of both tables should be the following:

Final Table

Parent SKU	Component	Sales
A	A1	10
A	A2	10
B	B1	15
C	C	20
D	D1	5
D	D2	5
D	D3	5
D	D4	5

Is it something we can do in Alteryx or do I have to do it in Excel?

Thanks,

Alex20

[echuong1 · Accepted solution]

This can be achieved with a join tool! See attached for an example.

[AlexP]

Hi echuong1,

You're right, it works, except for the Parent SKUs who don't have Component equivalent - Product C in my example.

I guess I can use the Union tool to combine the first extract (L) and the second (J). I would need a select tool between the join tool and the union tool to rename my "Component" column into "SKU" and remove the "Parent SKU" column in order to have 2 columns in each table...

Thank you for your help!

Alex