Data-Load-by-Folder-File-Merge

  
    D:\Dropbox\_\work\_prd\_data_www\investing.com\C_Fut\C_US_CL
D:\Dropbox\_\work\_prd\_data_www\investing.com\C_Fut\C_US_CL\C_US_USD_CME-NYMEX_Fut_CL.txt

  
    https://www.investing.com/commodities/crude-oil
https://www.investing.com/commodities/crude-oil-historical-data
C_US_USD_CME-NYMEX_Fut_CL.csv
C_US_USD_CME-NYMEX_Fut_CL_19830331-20260320.csv
Crude Oil WTI Futures Historical Data.csv
C_US_USD_CME-NYMEX_Fut_CL
  

  
    Data-Load-by-Folder-File-Merge
-----------------------------------------------------------------------
Crude Oil WTI Futures Historical Data_19830331-20030307.csv = Part 1
Crude Oil WTI Futures Historical Data_20030307-20220818.csv = Part 2
Crude Oil WTI Futures Historical Data_20220818-20260320.csv = Part 3
-----------------------------------------------------------------------
Crude Oil WTI Futures Historical Data_merged_19830331-20260320.csv = Merged Parts 1 to 3
-----------------------------------------------------------------------
Appending separate Excel Files using Power Query
Create a folder.
In the folder: put the csv files to be merged.
In the folder: Right Click > New > Microsoft Excel Worksheet 
               > "Crude Oil WTI Futures Historical Data_merged_19830331-20260320.xlsx"
Open the Excel file.
Excel > Data > Get Data > From File > From Folder
> Browse to Folder you created
> Open
> Select the 3 files to be merged
> Combine (dropdown)
> Combine and Transform Data
  > [Combine Files]
    > Parameter1
      > "Date" > OK
      > [Power Query Editor]
        > Select "Date" Column > Right Click > Remove Duplicates 
        > Select "Date" Column > Click on Header Dropdown > Sort Descending
        > Select "Source.Name" Column > Right Click > Remove
        > Close & Load
> New Worksheet with Folder Name will be created 
-----------------------------------------------------------------------

  

Contact