Log In
Register
Home
New Member
January 3, 2017
Offline
I've got a large number of input files which I process with a single power query. Using this I manage to read 100's of CSV files, manipulate the data and create a single table.
I now want to create two output tables from a single query.. e.g. 1st output table has all the input data and a 2nd output table with a subset of the input data. Can a single query create multiple tables?
I could run two queries, but seeing as an individual query takes 10 mins to run, I don't really want to run it twice.
See Answer
July 16, 2010
Offline
Hi Peter,
Welcome to our forum!
If you right-click the first query in the left hand query list of the Power Query editor, then select 'Reference', you'll create a second query based on the first query.
In regards to the slow refresh times, please see this link on ideas for improving Power Query refresh times.
Mynda
Answers Post
1 Guest(s)
