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

Question

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

23

Dataset B

A

BC

Desired Dataset

1

A

1B1C2A2B2C3A3B3C

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

Jean-Balteryx · Accepted Answer

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 Answer

Hi @AdamMina,

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

Workflow:

Hope this helps : )