How to join two unique datasets each with only one column and generate combination of both

[AdamMina]

Hi All,

I am struggling to find a way how to generate a dataset from two unique columns (A,B), in a way that each unique value in data set A would get expanded by all unique values from dataset B.

An example below should be better in describing what I am looking for.

Dataset A

1

2

3

Dataset B

A

B

C

Desired Dataset

1	A
1	B
1	C
2	A
2	B
2	C
3	A
3	B
3	C

I hope it makes sense, thank you all in advance :)!

[Jean-Balteryx · Accepted solution]

Hi @AdamMina ,

The "Append fields" tool is your friend ! It creates every combination of values from both sources !

Here is the documentation : https://help.alteryx.com/20212/designer/append-fields-tool

[atcodedog05 · Accepted solution]

Hi @AdamMina,

As @Jean-Balteryx mentioned you can use append tool like below to create combinations.

Workflow:

Hope this helps : )

[AdamMina]

Hi Both,

Works like a charm! 🙂 Thank you both for quick response.

Have a nice day.