Log In
Register
Home
March 13, 2022
Offline
Hello I think the question is clear and does not need an explanation. Please assume three tables in an Excel file and solve the problem with the function mentioned in the title.
July 16, 2010
Offline
Hi Farshad,
The tone of your email does not come across well. If you would like an answer to your question, it is courtesy to provide some data yourself rather than expect our volunteers to do the work for you. We do not know if the data in the three separate tables is the same, has the same headers etc. There are many assumptions to be made.
I recommend you rephrase your question and provide a file.
Mynda
March 13, 2022
Offline
You are absolutely right, a file is attached
October 5, 2010
Offline
Hi Farshad,
Why do you want to use List.Accumulate for this? You can just append (combine) the tables to create 1 table.
= Table.Combine({Table1, Table2, Table3})
Regards
Phil
March 13, 2022
Offline
Hello to Philip and Mynda . I had seen uses of List.Accumulate In order to understand more about this function, I asked the members to add this example as well. I am a beginner in programming and I am old, so I am trying to learn by seeing many examples
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Farshad,
List.Accumulate is not necessary in this scenario.
However, the query looks like this:
let
Source = List.Accumulate({Table1,Table2,Table3},#table({},{}),(state,current)=>Table.Combine({state,current}))
in
Source
List.Accumulate is an iterator. When we have a function (Table.Combine) that can combine tables in a single operation, iterators are no longer necessary.
What it does:
Iteration 1: Combines first table with the empty one (state is initially an empty table), state = Table1
Iteration 2: Combines first table with second table, state = Table1 & Table2
Iteration 3: Combines state with third table, state = Table1 & Table2 & Table3
1 Guest(s)
