Dataset Views: Best Practice to Remove Duplicates?

swagner
swagner 🟒
in Dataflows

I'm still wrestling with this topic... finding the best approach.

Any suggestions?

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon πŸ₯·

    Scott,

    Have you used GROUP BY to eliminate your duplicates? I just did that in ETL by using MAX on all the columns that could potentially be duplicated.

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • swagner
    swagner 🟒

    @MarkSnodgrass I have tried that some, but its a bit temperamental... I did a join after a group by and it brought over my new columns as "counts" first. Order in which things are done seems to be the issue. Was wondering if there was another method (other than group by) that would avoid those issues.

Categories