Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
6 years ago
Solved

filldown with condition

Hello,   i've a table that i want to filldown, with a condition, based on another column. it doesn't work here is my code   = if (#"Colonnes supprimées1"{+1}[Numero client] = #"Colonnes suppri...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjS0sDQ3NFXSUXLJT8kHUsGOQY4eQNrAQt/QQN/IwMBYKVYHWR0U4RG0NDA0tyRLMBYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Numero client" = _t, #"Nom client" = _t, #"Prenom client" = _t, #"Date naissance" = _t]),
    cols=Table.ColumnNames(Source),
    tab=Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue, cols),
   #"Grouped Rows" = Table.Group(tab, {"Numero client"}, {{"fill", each Table.FillDown(_,cols)}}),
    #"Expanded fill" = Table.ExpandTableColumn(#"Grouped Rows", "fill", {"Nom client", "Prenom client", "Date naissance"}, {"Nom client", "Prenom client", "Date naissance"})
in
    #"Expanded fill"
Anonymous's avatar
Anonymous
Not applicable
6 years ago
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjS0sDQ3NFXSUXLJT8kHUsGOQY4eQNrAQt/QQN/IwMBYKVYHWR0U4RG0NDA0tyRLMBYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Numero client" = _t, #"Nom client" = _t, #"Prenom client" = _t, #"Date naissance" = _t]),
    cols=Table.ColumnNames(Source),
    tab=Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue, cols),
   #"Grouped Rows" = Table.Group(tab, {"Numero client"}, {{"fill", each Table.FillDown(_,cols)}}),
    #"Expanded fill" = Table.ExpandTableColumn(#"Grouped Rows", "fill", {"Nom client", "Prenom client", "Date naissance"}, {"Nom client", "Prenom client", "Date naissance"})
in
    #"Expanded fill"
GeekAlfPro's avatar
GeekAlfPro
Helper V
6 years ago

Hi Rocco,

 

thanks a lot, it works fine !

thanks again

 

have a good day