Is there a way to copy data from a datasource and then delete the datasource while keeping the copy?

[Anonymous]

Hello,

I need to load a data source (CSV file) from a Jenkins job. So far, so good. The content of the CSV file is never the same except from one column. The problem is that I need to keep the previous week's data in Power Query ( even the column with the values that doesn't change ).

( I don't know if I've well explained so here's a detail of what I want to do )

I load the file example.csv :

The next week I want to load the same file but it's content has changed with :

But I want to keep the content of the file from the precedent week, so my table would look like this : 

Is there a way to do this in Power Query ?

[jovalle]

Hi, 

If I understand correctly, are you looking to essentially append the new CSV file to the old one? If so, you could import the new CSV file > Click on the old query > click on Append Queries > In the pop up window click the drop-down and select the new query > Disable Load from the new query by right clicking on the query. 

Hope this helps. 

Best