Hi all
I have grouped and summed the data using the summarise tool and then joined using the joined tool. the problem now is that the data is duplicated. I tried to remove the duplicates using the unique tool but it did not work.
any ideas?
for J anchor of joint tool use unique tool , this will remove duplicates
@Sifiso The join tool generating the duplicate rows because you have duplicates records in the summarize tool output, try to remove duplicate records from the summarise tool