Cartesian / cross join without using append join.

Question

Hi all,

I have two inputs and I need to do cross join without using a append tool. How it is done?

I tried using Tile tool by applying Equal Records but no luck. Output is shown in the workflow.

Please check and help.

Best Regards,

Teja

cross join without append tool.yxmd

philipmannering · Accepted Answer

Cross join without using the append tool:

philipmannering · Accepted Answer

Here's the code for a copy and paste

import pandas as pd

from ayx import Alteryx
from itertools import product

list1 = Alteryx.read('#1').iloc[:,0]
list2 = Alteryx.read('#2').iloc[:,0]

Alteryx.write(pd.DataFrame(product(list1,list2)), 1)

MarqueeCrew · Accepted Answer

Create join field on both inputs as:

"J"

join in that field.

cheers,

mark

Christina_H · Accepted Answer

If you can't use append, you could create a joining field with the same value in each row:

philipmannering · Accepted Answer

If you just want to duplicate each month four times then you could use the Generate Rows tool,

AZuc · Accepted Answer

@stj1120 , I would do the same as @Christina_H . Create a "fake" key and use Join Tool.