Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Fill in values where id is duplicated

I am trying to fill in values in the column "tags_Sprints" where the id is duplicated.

Put another way, if "tags_Sprints" is not null, I want the value to show in all instances within that same id.

 

So, if this is the table:

I want the column tags_Sprints (or a new column) to show values like this:

Is that clear enough?

 

EDIT: attaching the table.

idtagstags_KI  tags_SprintsSprint_Date
2306    
2305    
2304KI-7412KI-7412  
2304Sprint2021.12.14 Sprint2021.12.1412/14/2021
2303    
2302KI-7413KI-7413  
2301KI-7411KI-7411  
2301Sprint2021.12.14 Sprint2021.12.1412/14/2021
2300    

 

Thanks in advance.

Need Help

6 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      OK. I edited and pasted the data into a table.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago
        let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjI2MFPSUVJAwbE6YAlTXBImQI63p665iaERCgtDUXBBUWZeiZGBkaGeoZGeoQlUDRZhQyN9QxN9kBBMvzEu2xF2GqOwUBQZwqVQWRiKKHGiAaYTYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, tags = _t, #"tags_KI  " = _t, tags_Sprints = _t, Sprint_Date = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,each [tags_Sprints]=" ",
(k)=> List.Max(Table.SelectColumns(Table.SelectRows(Source, each [id]=k[id]), "tags_Sprints")[tags_Sprints]),
(orig, test, repl)=> if test then repl else orig,{"tags_Sprints"})
in
    #"Replaced Value"

        How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

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