Cartesian / cross join without using append join.

[stj1120]

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

[PhilipMannering · Accepted solution]

Cross join without using the append tool:

[PhilipMannering · Accepted solution]

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 solution]

Create join field on both inputs as:

"J"

 join in that field. 

cheers,

 mark

[Christina_H · Accepted solution]

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

[PhilipMannering · Accepted solution]

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

[AZuc]

@stj1120 

just out of curiosity... why not use Append Fields if it's the tool made for cross join?

[stj1120]

Hi @AZuc 

Yes, I kow the use of Append Tool. Just wanted to try and know if we can achieve cross join results without using Append tool. 

Kindly let me know how to achieve it. 

Thank you.

Teja. 

[AZuc · Accepted solution]

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