Cartesian / cross join without using append join.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Preparation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Cross join without using the append tool:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Create join field on both inputs as:
"J"
join in that field.
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you just want to duplicate each month four times then you could use the Generate Rows tool,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
just out of curiosity... why not use Append Fields if it's the tool made for cross join?
Sales Engineer - LATAM -
Alteryx, Inc.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@stj1120 , I would do the same as @Christina_H . Create a "fake" key and use Join Tool.
Sales Engineer - LATAM -
Alteryx, Inc.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You may have more than 16 records in the source, and the append tool will over-generate, creating massive duplicative records. In those situations, you can use a formula tool on each dataset to create a new field named dummy_key and use it to connect the datasets to a join tool.
