Forum Discussion

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost Prodigy
4 months ago
Solved

List.Generate, make behave like Accumulate or XL REDUCE

Hi, my staring point was this, i wanted to accumute fieds to a  record;  so i used;  let f = {List.Sum, List.Max, List.Average}, head = {"sum", "max", "avg"}, pos = {0, 1, 2}, ...
Need Help
Show and Tell
  • Ahmedx's avatar
    Ahmedx
    4 months ago

    and try this

    let 
f    = {List.Sum,List.Max, List.Average},
head = { "sum", "max", "avg"}, 
val = {2,3,1,5,2,1},
to=
  List.Generate(()=> [ i = 0, j = Record.AddField( [],head {i}, f{i}(val) )  ],
                 (x)=> x[i] <= List.Count( head)-1, 
                 (x)=> [i = x[i] + 1, j = Record.AddField( [],head {i},f{i}(val))
],
                 (x)=>x[j])
in
  Record.Combine( to)

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
4 months ago

and try this

let 
f    = {List.Sum,List.Max, List.Average},
head = { "sum", "max", "avg"}, 
val = {2,3,1,5,2,1},
to=
  List.Generate(()=> [ i = 0, j = Record.AddField( [],head {i}, f{i}(val) )  ],
                 (x)=> x[i] <= List.Count( head)-1, 
                 (x)=> [i = x[i] + 1, j = Record.AddField( [],head {i},f{i}(val))
],
                 (x)=>x[j])
in
  Record.Combine( to)

  • Dicken's avatar
    Dicken
    Icon for Post Prodigy rankPost Prodigy
    4 months ago

    Thanks, will work through properly,  i like anythiing that invvolvves records 😊

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      4 months ago

       

      let
    f = {List.Sum, List.Max, List.Average},
    head = {"sum", "max", "avg"},
    val = {2, 3, 1, 5, 2, 1},
    to = List.Generate(
        () => 0, 
        (x) => x <= List.Count(f) - 1, 
        (x) => x + 1, 
        (x) => Record.FromList({f{x}(val)}, {head{x}})
    )
in
    Record.Combine(to)
============================
let
    f = {List.Sum, List.Max, List.Average},
    head = {"sum", "max", "avg"},
    val = {2, 3, 1, 5, 2, 1},
    
    to = List.Generate(
        () => 0, 
        (x) => x <= List.Count(f)-1, 
        (x) => x + 1,
        (x) =>  Record.AddField([],head {x}, f{x}(val) ))
in
    Record.Combine(to)