Converting my 12 joins + union into multijoin

[wonka1234]

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?

[TheOC]

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

[Kamran1991]

Hi @wonka1234 ,

In this case, an iterative macro can help you.

[wonka1234]

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

[TheOC]

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

[wonka1234]

@TheOC  Thanks theOC, I cannot see the attachment.

[Ben_H]

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]

hey @wonka1234 

Apologies, please find attached!

Cheers,
TheOC