Forum

Add rows incrementa...
 
Notifications
Clear all

Add rows incrementally to Power Query Table

3 Posts
2 Users
0 Reactions
228 Views
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hi,

i have table like here:

Col1Col2Col3

1 2 3

one row and values are changed dynamically from tab:Screenshot_207.png

and clicking button should append the changed row into TableOutput. 
How to do this in Power Query? 

Best,
Jacek

 
Posted : 28/08/2021 5:46 am
(@catalinb)
Posts: 1937
Member Admin
 

First, read the source table and load to output worksheet. For now, it's just a mirror of the source table.

Next, go to the sheet with the output table you just created and load it again into power query (name the query as Output), but this time do not load to worksheet, just as a connection.

Now, edit the first query to add a final custom step:

Custom1 = Table.Combine({Output,Source})

2021-08-28.png

 
Posted : 29/08/2021 1:32 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

thank you,

let me check

Best wishes,

Jacek

 
Posted : 29/08/2021 1:31 pm
Share: