Forum Discussion
Fill in values where id is duplicated
Super UserPlease 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.
OK. I edited and pasted the data into a table.
- lbendlin
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".
Thank you lbendlin !
It works perfectly on a new Query, however, when I apply it to my full table, it doesn't work.
It doesn't break the query, but it doesn't fill in any values either.
What do you think is going on? What do you need?
The only difference is that blank values in my full table are "null" instead of blank, but I don't that should affect the output.- lbendlin
Please provide sanitized sample data that fully covers your issue.