Forum Discussion

jtomczyk's avatar
jtomczyk
Icon for Helper I rankHelper I
4 years ago
Solved

merge duplicate power query

Hallo,

I have two sources of data. I have used append queries to join them. As a result for some of them I have duplicate rows.

I would like to have only one line for each project code and to take the values from the second line if the value on the first one is null

Any idea how to do that?

Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi jtomczyk, You could use a group by method in Powerquey and try using Max to return the values you need. 

  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi jtomczyk 

    after you append queries, then 

    (1) replace blank cells with null

    (2) fill down

    (3) fill up

    (4) remove duplicate rows.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi jtomczyk, You could use a group by method in Powerquey and try using Max to return the values you need. 

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi jtomczyk 

    after you append queries, then 

    (1) replace blank cells with null

    (2) fill down

    (3) fill up

    (4) remove duplicate rows.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.