Forum Discussion

BazzaBoyes's avatar
BazzaBoyes
Copper Contributor
Feb 07, 2022
Solved

CSV file----->> Excel Spread Sheet-Appended Sync

Hi, I am trying to maintain an excel spreadsheet using a data link from a CSV file. This is straightforward, BUT here's the challenge: I need the various rows to append when there is a change in th...
BI & Data Analysis
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 07, 2022

    BazzaBoyes In Power Query, connect to the CSV file (source), do the necessary transformations and load into Excel. Now, in the same query connect to the table loaded into Excel (source2) and append it to source. Remove duplicates.

     

    Example attached.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 07, 2022

BazzaBoyes In Power Query, connect to the CSV file (source), do the necessary transformations and load into Excel. Now, in the same query connect to the table loaded into Excel (source2) and append it to source. Remove duplicates.

 

Example attached.