Forum Discussion
Problem with GROUP BY for Duplicates
Hi imani_tech,
Made a small CSV file with the same fields as you have:
UserDelegatePermissions
A AA AAA A AA BBB A AA BBB B BB AAA C CC AAA C CC BBB C CC CCC C CC CCC As you can see I have repeated items, then made the grouping in Query editor and the result gives the duplicate in the count rows:
Are you already getting the information from the CSV or from the SQL that you had in your previous post?
Regards,
MFelix
It should work but it isn't.
Super UserHi imani_tech,
Made a small CSV file with the same fields as you have:
UserDelegatePermissions
| A | AA | AAA |
| A | AA | BBB |
| A | AA | BBB |
| B | BB | AAA |
| C | CC | AAA |
| C | CC | BBB |
| C | CC | CCC |
| C | CC | CCC |
As you can see I have repeated items, then made the grouping in Query editor and the result gives the duplicate in the count rows:
Are you already getting the information from the CSV or from the SQL that you had in your previous post?
Regards,
MFelix
I created a new query and followed your steps again. It worked! Thank you such much.