Forum Discussion
How to loop {x} and combine to list.
I don't want to continue creating more JsonX variable and then putting each one in the combined list
let ....
#"Json0" = Json.Document(#"Expanded logs"{0}[logs.Content],1252),
#"Json1" = Json.Document(#"Expanded logs"{1}[logs.Content],1252),
#"Json2" = Json.Document(#"Expanded logs"{2}[logs.Content],1252)
#"Combined" = List.Combine({#"Json0", #"Json1", #"Json2"})
in
#"Combined"
1 Reply
You probably want to use List.Accumulate. It is a pretty complex function, so I recommend you google for some tutorials on it or check out this article.
It should do what you need. You may need to check out List.Generate as well. Equally as complex, but may be needed to generate those numbers you are using as an index in the brackets. Again, do some googling for articles or online videos.
