Linking two tables with no unique identifier

Stiofain

Having difficulty combining two tables in Alteryx.

Table A and Table B are simplified versions of my data & are completely different but need to be joined as shown below:

Table A

Customer

A

B

C

D

Table B

Product

1

2

3

4

Output that I'm looking for:

Customer	Product
A	1
A	2
A	3
A	4
B	1
B	2
B	3
B	4
C	1
C	2
C	3
C	4
D	1
D	2
D	3
D	4

i.e. I'm looking for each product to be lined up in a row for each customer. 

Any ideas of how this could be configured in Alteryx Designer? Maybe an iterative macro?

fmvizcaino

Hi @Stiofain ,

Since you want all possible combinations of both datasets, you can use the append fields tool to achieve that result.

Best,

Fernando Vizcaino

2020-06-29 Linking two tables with no unique identifier.yxmd