I have over 10 joins with alot of data, is there a way to speed this up?

[wonka1234]

Hi,

I have alot of joins in my workflow, is there a way to optimize this? When i use my data (over 5 million rows in dataset B) it takes over 2 hours to join.

Please see attached sample data.

[messi007]

@wonka1234,

Have you tried the multi-joint tool :

If you are working with database try to use in-db tools it will excute the querys on the database server.

Hope this helps !

Regards

[Qiu]

@wonka1234 
It still takes me two join tools. 

[wonka1234]

@Qiu  Im getting an error on your cross tab about the header field and data field cannot be the same. Why does it say this?

[Qiu]

@wonka1234 
It works fine on my end and it looks like this.