Forum Discussion
Dicken
2 years agoPost Prodigy
let versus record
Hello,
can someone explain why the record version does not give result in genlist;
let alist = {"a","b","c","c","c","d","d"} ,
lc = List.Count (alist )
in
List.Generate( ()=> [ i = 0 , x = true ] ,
each [i] < List.Count( alist) -1,
each [ i = [i]+1, x = alist{[i]} = alist {[i]+1} ]
)
[ alist = {"a","b","c","c","c","d","d"} , lc = List.Count (alist ) ,
genlist = List.Generate( ()=> [ i = 0 , x = true ] ,
each [i] < lc =1,
each [ i = [i]+1, x = alist{[i]} = alist {[i]+1} ]
) ]as a test I also tried ;
[alist = {1..10} ,
b = List.Transform( alist, (A)=> A * 10 ) ]
and this does allow b to work on alist, so I don't see a problem in principal , any solution / explanation.
Richard.
what's this?
each [i] < lc =1
8 Replies
- AlienSxSuper User
what's this?
each [i] < lc =1 - AhmedxSuper User
Is this what you are looking for?
[ alist = {"a","b","c","c","c","d","d"} , lc = List.Count (alist ), genlist = List.Generate( ()=> [ i = 0 , x = true ] , each [i] < List.Count( alist) -1, each [ i = [i]+1, x = alist{[i]} = alist {[i]+1} ] ) ][genlist]- DickenPost Prodigy
No I'm looking for an answer as to why the let statement gives a result and the record does not
that was the question asked. .
- PwerQueryKeesSuper User
What do you mean by 'Result'. The let statement has an in clause giving a result. The record does not. The record itself is the result.
I suspect you did not give us the full context of the query, so hard to tell what causes any difference.
- DickenPost Prodigy
I mean result the 'in' statement or the gen of record.