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

To get such a result, you need to use neither List.Accumulate nor List.Generate

let
  f    = (x)=> {List.Sum(x), List.Max(x), List.Average(x)},
      head = {"sum", "max", "avg"},
      val  = {2, 3, 1, 5, 2, 1},
   to =     Record.FromList(f(val), head)
    in to

 

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

    yes, i know , but i wanted to use LIst.Generate,  can it be done ? 

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

      pls try

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