Power Query table management

[ben_sorensen]

Hi I am new to this message board, but I am using power Query it creates a new table when I merge and upend data.

For example I upended three tables with ~50,000 lines each so I have the original files and the upended the file (that's fine) then I start merging in data and as I do it creates a new table with 150,000 lines (two of these now) then I merge more data in and it creates another new table (3 tables with 150,000 lines each with an additional step of the merging) I want to go through and delete previous tables but that would ruin everything, it's really inefficient to have that much data created through this file, and I know that I am missing something.

Any help would be appreciated.

 

[Ron Coderre]

It sounds like you're loading each query's results into a worksheet. If that's what you're doing, it's unnecessary. PQ queries can reference other queries directly. When you're finished editing each query load to "connection only". You don't need to store the results in a worksheet until the end...if at all.

Does that help?

 

[ben_sorensen]

It sounds like you're loading each query's results into a worksheet. If that's what you're doing, it's unnecessary. PQ queries can reference other queries directly. When you're finished editing each query load to "connection only". You don't need to store the results in a worksheet until the end...if at all.

Does that help?

Absolutely, let me give that a shot and see, but that sounds 100% correct.

Thanks
Ben