Log In
Register
Home
February 1, 2019
Offline
Hi,
i haveto import at once a lot of entirely separated tables in PQ. What is the best approach to do and how to do this?:
1) Import all tables (about 50) to one worksheet on Excel and place them one by one in horizontal view (or one below another) - how to do this?
2) import all tables - every table to different specific worksheet? And how to do this in Power Query in one query ?
Please help,
Jacek Antek
See Answer
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Do the tables have the same structure or are they each individual?
If they all have same structure you can use Power Query, where you load the files from a folder. See this article about that approach.
If they have different structure then it is easier to just copy and paste into one file.
Br,
Anders
October 5, 2010
Offline
Hi Jacek,
Are we talking about tables in Excel workbooks?
As Anders said, you should use Get files from folder in Power Query. What's the goal? Do you want to merge these tables into fewer tables?
Regards
Phil
February 1, 2019
Offline
Hi,
thanks!
I do not want to merge tables and combine them. They are just different structure tables in CSVs...
And want to output them into multiple worksheets (or single one one next to another)
Best,
Jacek
July 16, 2010
Offline
Hi Jacek,
If it's 50 separate queries you want outputted, then you need 50 separate queries that you create one by one (after all, they all have different starting layouts that need converting), and I'd put them into their own sheet unless you can be sure they won't ever change shape/grow in future refreshes, in which case you can put them side by side in a single sheet. Either way, there are no shortcuts, sorry.
Mynda
Answers Post
February 1, 2019
Offline
Thank you very Much Mynda!
Jacek
February 1, 2019
Offline
Hi,
i would like to refresh topic.
I have chosen to use seperate sheet for each table.
It is possible to do this somehow automatically?
I mean refresh folder source from PQ and use PQ M language or VBA to output each table to seperate folder?
Best,
Jacek
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
The output destination is not controlled in M language, so there is no way to write in the query the destination sheet. (yet)
Only VBA can help...
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
The output destination is not controlled in M language, so there is no way to write in the query the destination sheet. (yet)
Only VBA can help...
1 Guest(s)
