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?
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
Hi @wonka1234 ,
In this case, an iterative macro can help you.
@TheOC No , I am not to familiar with append fields.
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
@TheOC Thanks theOC, I cannot see the attachment.
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
hey @wonka1234
Apologies, please find attached!Cheers,TheOC
