Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Converting my 12 joins + union into multijoin

wonka1234
10 - Fireball

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?

 

 

7 REPLIES 7
TheOC
15 - Aurora
15 - Aurora

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


Bulien
Kamran1991
11 - Bolide

Hi @wonka1234 ,

 

In this case, an iterative macro can help you.

wonka1234
10 - Fireball

@TheOC  No , I am not to familiar with append fields.

TheOC
15 - Aurora
15 - Aurora

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.

TheOC_1-1639877106540.png


Cheers,
TheOC


Bulien
wonka1234
10 - Fireball

@TheOC  Thanks theOC, I cannot see the attachment.

Ben_H
11 - Bolide

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

 

 

TheOC
15 - Aurora
15 - Aurora

hey @wonka1234 

Apologies, please find attached!

Cheers,
TheOC


Bulien
Labels
Top Solution Authors