Forum Discussion

Charly727's avatar
Charly727
Copper Contributor
Mar 21, 2020

MOVE DATA FROM DIFFERENT SHEETS AND TO COMPILE IT IN ONLY ONE TABLE

Hello Everybody I am trying to create an excel file that takes the information of the different sheets (define range) and to put it automatically in a table.  The question is that new sheets can be...
excel
Charly727's avatar
Charly727
Copper Contributor
Mar 29, 2020

ExcelExciting 

 

Hi Faraz, 

I have followed the explanations in you video and I have one problem with the updating. 

When I try to update the power query. Old data are maintained in the power query sheet , even if I delete one sheet the power query after updating maintain those data

 

Can you help please? It is an important project for me and I am confusing how to repair it

Carlos

ExcelExciting's avatar
ExcelExciting
MVP
Mar 29, 2020

Hi Charly727 

 

OK, so here is the game.. 

Basically power query is ETL tool which means it will

Extract the information from your source file like XLSX,TXT,CSV,PRN etc

Transformation is the query editor, where you combine, make changes, shape you data

Load is finally once your are satisfied with your transformation load it to your workbook/date model and do your stuff.

 

Note : If you make any changes to your source file & hit refresh it will reflect the changes in the query file. example as you said when you deleted the file it deleted the information from the query file as well.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer

Resources