Power Query Tables Reading Each Other's Tables

dannie

New Member
Joined
Dec 29, 2014
Messages
34
I am very new to using Tables and Queries. Basically I'd like whenever I add a line of data in one table, to have it added to the Power Query Table on another sheet. The other sheet will still have data on it, so the newest data I would like to add it, not replace it.

I want to also have the tables appending each other. Pending table reading from PPR table and Approved table, as well as Approved table reading from PPR table and Pending table, and so on with other tables.

INFO:
-Lines from original data table (PPR Table) will move to new/appropriate table based on their Status
-Status can changes once on another table (ex: pending can be approved and then go back to pending status). I need to be able to have these move to their correct tables.
-I don't want what is already on the Table to be deleted, just adding lines until the Status has changed

Here is the part of the Advanced Editor on the PENDING table:
let
Source = Excel.CurrentWorkbook(){[Name="PPR"]}[Content],
#"Appended Query" = Table.Combine({Source, PPR, APPROVED}),

Any help or guidance is appreciated, thank you.

-dannie

1659841009880.png
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top