Forum Discussion
rnnbr
May 09, 2022Copper Contributor
Copy Power Query result data to a Table object
Hi all, I'm using Excel 365, in a workbook I have : 1. Worksheet in which I have a Power Query running, the PQ is taking a sub-set of data from a different file. At the moment the PQ filter ...
Riny_van_Eekelen
May 10, 2022Platinum Contributor
rnnbr Yes and no. I see what your are working on but don't really understand what you need. You have a table that comes out of PQ (the green one) and then you want to include it in the blue one where extra information is added. Perhaps you want to add a column to a PQ generated table and keep this additional information synchronised when you refresh PQ. If so, that's possible if you follow some basic steps. Google for "self referencing table power query" and you'll find many resources that describe the process.
rnnbr
May 11, 2022Copper Contributor
Riny_van_Eekelen for various reasons I need to populate the Table, not only that there is more logic on it but it’s then being used by other worksheets, I’ll try to start uncovering how to loop through the PQ results and copy the data to the Table