Hello Everyone,
I have a strange problem, one of my joints not progressing pass 50%. I have tried many times and waited many hours. It's a simple join one field to a one field.
Thank you
Have you looked at how many columns and rows are created?
It used to happen to me when I found out that I was reaching 11,000 columns and mutliplied the rows to a point the computer could not process.
It may not be the solution but an option to explore.
Are there duplicate values in your join columns or are there null values in these columns? My guess is you are doing a many-to-many join which is making your dataset much larger. One thing I've done in the past is add the random sample tool before one side of my join and only send a small sample into the join tool. Then look at how many rows your dataset has before the join and after the join.
It's 35 columns.
Thank you! The random sample tool might be a good idea.
