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"
GeekAlfPro's avatar
GeekAlfPro
Helper V
6 years ago

 

here are the dummy data

in red the wanted filldown 

when "Numero Client" change, i don't want a filldown anymore

maybe the trouble come from some of my blue values are blank

 

Numero clientNom clientPrenom clientDate naissance
1189715DodoSARAH08/10/2003
1189715DodoSARAH08/10/2003
1189715DodoSARAH08/10/2003
1190179?   
1190179   
1190179   
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