Converting my 12 joins + union into multijoin
- 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 these joins make my workflow run very slow. I am reading about multi join, will this make my workflow faster?
My actual workflow has millions of records.
Can anyone help with this?
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hey @wonka1234
If you only have two datasets I dont think you need this many joins to achieve your output (atleast, on your example workflow).
Have you thought of using the Append Fields tool?
Cheers,
TheOC
- 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
@TheOC No , I am not to familiar with append fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hey @wonka1234
Please find attached - i have adjusted your workflow - and you should see it produces the same output in one tool.
I have left your previous solution, so you can compare outputs and make sure they are the same.
Cheers,
TheOC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@TheOC Thanks theOC, I cannot see the attachment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wonka1234,
I think it's just the sample data you've provided but I'm not sure what this is actually supposed to do?
Why does input 1 which has a bunch of duplicate values join to a column of 35 identical values in input 2?
Can you provide more of an explaination - or better sample data?
Regards,
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
