Results 1 to 2 of 2

Thread: Duplicates after Power Query Left Join
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2016
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Duplicates after Power Query Left Join

    Hi,

    I am just wondering if anyone knows why after each time I do a left join merge with Power Query I get a lot of duplicate rows? Is there a reason within my data for why this is happening or is it something that happens normally?

    Thanks!

  2. #2
    New Member
    Join Date
    Apr 2015
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Duplicates after Power Query Left Join

    You are using column (in join) which is not distinct in one of the tables. This is the only reason.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •