Forum Discussion
Filling Up Based on Other Column Value
Could someone advise please how to perform the following transformation, I want to fill up Column: Resigned till the value of Column: Name changes, meaning, I want to fill up for all the cells relate...
You have dash in 2nd argument of Table.FillUp. It should be removed...
You were not encouraged to do that with my code. 🙂
I've tried to upload a photo for the data but it didn't allow me
But here you go, please find the table
Group by Name column >
FillUp Resigned column in nested table >
Expand
By applying this, the fill up will go for instance for HR ID 2499, which is valid) but for 2498 and 2497 as well which is invalid.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUVKK1cHGMEJmRKYWg9nGMEFMhglWBlhjLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Resigned = _t]), Nulls = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"Resigned"}), Grouped = Table.Group(Nulls, {"Name"}, {{"Gr", each Table.FillUp(_,{"Resigned"}), type table [Name=nullable text, Resigned=nullable text]}}), Expanded = Table.ExpandTableColumn(Grouped, "Gr", {"Resigned"}, {"Resigned"}) in ExpandedI'm so sorry, it seems that I cannot comprehend the script really, could you show me a screenshot of Group By step? Something like that