What is the basic difference between PowerPivot and power query – I am pulling data from multiple sources (huge csv files and other formats) and then i would need to join them and then manipulating them and putting them in one sheet of excel. Which one will be better in this case? Power pivot or power query
Microsoft ExcelMicrosoft SQL ServerMicrosoft ApplicationsOffice Productivity
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
In what form? If it's not a pivot table, you're probably better off with PQ.
Jim Horn
^^^ Along these lines, it might not be a bad idea for you to paint us a picture of what exactly your business needs are, and how large these files are, as there are other solutions that may be more ideal.
Rayne
ASKER
Thank you, I was out sick so sorry for the delay
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
In what form? If it's not a pivot table, you're probably better off with PQ.