Join Tool Not Working

[Rhaldhar]

Hi Team,

Could you please help me the know why join tool is not working on attached data. Also, refer below workflow.

Thanks,

Rajeev

[davidskaife · Accepted solution]

Hi @Rhaldhar 

It appears to be due to the summed values, it's worth noting you shouldn't join on data type Double; but if you add an additional Formula tool after the Summarize tool and round the summed columns, the join conditions will then work

[geoche]

It's not recommended to join by double because of the rounding errors

You can with two selects change the types of the Sum columns into V_WString and in the join specify Double for the output :)

Spoiler

You can also round with Formula before the join