Better way to replace many joins

[wonka1234]

Hi,

I have a workflow that does many joins. 

I am joining 10 fields from dataset A(Left), to 1 field in dataset B(right) in each join, Taking the left output and inner of each join and using a union to bring these fields together.

Is there a faster way of accomplishing this? It seems to take my workflow long to run.

[csmith11]

Here my version of the python mock up.

[wonka1234]

Please see attached workbook, hopefully this is useful. 

My real data is alot more rows but this gives you the general idea.

[wonka1234]

@csmith11  sorry didnt see your workflow. Would you be able to try with my attached one?

[wonka1234]

@csmith11  , sorry to bother you, wondering if you looked at my post.

[csmith11]

Give this a try.  It works for the sample use case you presented.