Hi Team,
Could you please help me the know why join tool is not working on attached data. Also, refer below workflow.
Thanks,
Rajeev
Solved! Go to 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
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 :)
You can also round with Formula before the join