rank can be used in the custom sql and also distinct function
You can remove duplicates using COUNTD in tableau. But you are not allowed to delete.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!