Log In
Register
Home
New Member
March 18, 2019
Offline
I have a query (Table_Budget), containing +/- 2000 rows with a ID in a column. I want to link this column to another query (Table_Jobs) which contains the same ID. But, in this other query, there are more than 400.000 rows and in Power Pivor I receive an error that I do not have enough memory.
Is it possible to query Table_Jobs where only the rows remain with the same ID as in Table_Budget?
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 Filip,
Is that a Power Query error or a Power Pivot error? You mentioned that Power Pivot raised the error, but I guess it's just a typo.
If it's power query you meant, you can try to filter the Jobs table:
-step 1: build the ID list from Budget table:
Then, add a new column in Jobs query, with this formula:
This column will contain -1 values for ID's not found in Budget, so you should filter these out to reduce the size of the Jobs table in Power Pivot.
New Member
March 18, 2019
Offline
Hello,
I receive "error" in all record of this new column
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
Can we see a sample file?
1 Guest(s)
